Re: creating database users

[peter le roux]

OK the first one:
---------------------
Host: 127.0.0.1
Database: mysql
Generation Time: Dec 19, 2012 at 07:54 AM
Generated by: phpMyAdmin 3.5.1 / MySQL 5.5.25a-log
SQL query: select user,host,password from mysql.user LIMIT 0, 30 ;
Rows: 7
user host password
root localhost
root 127.0.0.1
root ::1
localhost
BOREHOLES % *A4F642AD2B1F2113B35F87DE02ACD7E307256A3A
peter % *ABF1B1EAE9F137AE57641E5E149A723B4B3871ED
me % *71C7ED15653FF7DB1893396D87FA6F57BD2A52D6
---------------------
and the second one:
---------------------
Host: 127.0.0.1
Database:
Generation Time: Dec 19, 2012 at 07:58 AM
Generated by: phpMyAdmin 3.5.1 / MySQL 5.5.25a-log
SQL query: show grants for 'BOREHOLES';
Rows: 2
Grants for BOREHOLES@%
GRANT ALL PRIVILEGES ON *.* TO 'BOREHOLES'@'%' IDENTIFIED BY PASSWORD '*A4F642AD2B1F2113B35F87DE02ACD7E307256A3A' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `testing_db`.* TO 'BOREHOLES'@'%' WITH GRANT OPTION
----------------------