Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pi@raspberrypi:~ $ mysql -u root -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or g.
- Your MySQL connection id is 38
- Server version: 5.5.59-0+deb8u1 (Raspbian)
- Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
- mysql> SELECT user,host,password FROM mysql.user WHERE user='';
- ERROR 1142 (42000): SELECT command denied to user 'root'@'localhost' for table 'user'
- mysql>
- mysql> status
- --------------
- mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (armv7l) using readline 6.3
- Connection id: 38
- Current database:
- Current user: root@localhost
- SSL: Not in use
- Current pager: stdout
- Using outfile: ''
- Using delimiter: ;
- Server version: 5.5.59-0+deb8u1 (Raspbian)
- Protocol version: 10
- Connection: Localhost via UNIX socket
- Server characterset: latin1
- Db characterset: latin1
- Client characterset: utf8
- Conn. characterset: utf8
- UNIX socket: /var/run/mysqld/mysqld.sock
- Uptime: 9 min 54 sec
- Threads: 1 Questions: 121 Slow queries: 0 Opens: 48 Flush tables: 1 Open tables: 41 Queries per second avg: 0.203
- --------------
- mysql>
- mysql> SHOW GRANTS;
- +--------------------------------------------------------------------------+
- | Grants for root@localhost |
- +--------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD <secret> |
- +--------------------------------------------------------------------------+
- 1 row in set (0.00 sec)
- mysql>
Add Comment
Please, Sign In to add comment