On Saturday 14 May 2005 15:33, Bob Rea wrote:
On Sat May 14 2005 2:33 pm, Scott Leighton wrote:
Use the commandline client, mysql to get access to the server. There's a tutorial here http://dev.mysql.com/doc/mysql/en/tutorial.html
My question was how to do precisely that. The tutorial referred to says: shell> mysql -h host -u user -p Enter password: ********
My question is how to find out what that password is.
From the manual: http://dev.mysql.com/doc/mysql/en/adding-users.html After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts: mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';