Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'mhauser'@'127.0.0.1' IDENTIFIED BY 'password';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'mhauser'@'192.168.1.46' IDENTIFIED BY 'password';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> \q
- Bye
- [gmontee@localhost ~]$ mysql -h 127.0.0.1 -u mhauser -ppassword
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 38
- Server version: 10.0.16-MariaDB-log MariaDB Server
- Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> SELECT CURRENT_USER();
- +-------------------+
- | CURRENT_USER() |
- +-------------------+
- +-------------------+
- 1 row in set (0.00 sec)
- MariaDB [(none)]> SHOW PROCESSLIST;
- +----+-------------+-----------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | Id | User | Host | db | Command | Time | State | Info | Progress |
- +----+-------------+-----------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | 5 | system user | | NULL | Connect | 319645 | Waiting for master to send event | NULL | 0.000 |
- | 6 | system user | | NULL | Connect | 319426 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 |
- | 38 | mhauser | 127.0.0.1:40508 | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
- +----+-------------+-----------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- 3 rows in set (0.00 sec)
- MariaDB [(none)]> \q
- Bye
- [gmontee@localhost ~]$ mysql -h 192.168.1.46 -u mhauser -ppassword
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 39
- Server version: 10.0.16-MariaDB-log MariaDB Server
- Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> SELECT CURRENT_USER();
- +----------------------+
- | CURRENT_USER() |
- +----------------------+
- +----------------------+
- 1 row in set (0.00 sec)
- MariaDB [(none)]> SHOW PROCESSLIST;
- +----+-------------+--------------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | Id | User | Host | db | Command | Time | State | Info | Progress |
- +----+-------------+--------------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | 5 | system user | | NULL | Connect | 319662 | Waiting for master to send event | NULL | 0.000 |
- | 6 | system user | | NULL | Connect | 319443 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 |
- | 39 | mhauser | 192.168.1.46:54299 | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
- +----+-------------+--------------------+------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- 3 rows in set (0.00 sec)
- MariaDB [(none)]> \q
- Bye
Advertisement
Add Comment
Please, Sign In to add comment
