Posts

Showing posts with the label databases

Tips on MySQL Accounts in Sguil VM

In an otherwise unremarkable book on MySQL , I found good advice on database accounts and authentication. Here is what the accounts look like in the Sguil VM I just released. taosecurity:/home/analyst$ mysql -u root -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.18 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select user, host, password from user; +-------+-----------------------------+-------------------------------------------+ | user | host | password | +-------+-----------------------------+---------...