or as the docs read:
shell> mysqladmin password <your password> John Daisley wrote:
The root Password will be blank after initial install. You can set it at a shell prompt with commands something like this... shell> mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd'); mysql> FLUSH PRIVILEGES; mysql> EXIT; Where newpwd is your desired password. Best to secure or delete all accounts with blank passwords :) You can then start MySQL administrator and log in using the username root, the password you specified in the SET PASSWORD command and the host of localhost. Regards John I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse thestupid questions ... 1. I have just downloaded and successfully installed MySQL v5.1 on my MacBook Pro running OS X 10.5.6 2. I have also downloaded and installed MySQL Tools: Administrator & Query Browser (I come from a Visual Basic & MS SQL Server 2000/2005 environment) When you install MS SQL server the default login is "sa" with a blank password. My question is; How do I login (connection settings) to MySQL (for Administrator and Query Browser tools)? (I start my server by going to settings and then MySQL icon, Start Server, so my server is running) Unfortunately, I have never seen MySQL in action nor do I know anyone to ask/show me how to get started. ______________________________________________ This email has been scanned by Netintelligence http://www.netintelligence.com/email
