Re: Newbie First Use Connection Question - Mac OSX 10.5.6
or as the docs read:
shell> mysqladmin 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 the
stupid 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
Re: Newbie First Use Connection Question - Mac OSX 10.5.6
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 the
> stupid 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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
