Re: Setting the password for root user in mysql

2002-09-30 Thread Clayburn W. Juniel, III


On Monday, September 30, 2002, at 03:03  24h, Palash Mohanlal Kasodhan 
wrote:

 Hi everyone,
 I am just starting to work with MySql on MAC OS X.When i
 installed mysql i got the following message :

 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
 done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
 /usr/local/bin/mysqladmin -u root -h localhost -p password 
 'new-password'

try:

/usr/local/bin/mysqladmin -u root password 'new-password'

with the single quotes.

--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.com
--


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Setting the password for root user in mysql

2002-09-30 Thread tlr7425

Is MySQL running?
Use Process Viewer to see if there is an entry for mysqld.

If not, I would ask if you issued the install_db command and then 
started mysql.

Ted

On Monday, September 30, 2002, at 06:03  PM, Palash Mohanlal Kasodhan 
wrote:

 Hi everyone,
 I am just starting to work with MySql on MAC OS X.When i
 installed mysql i got the following message :

 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is
 done with: /usr/local/bin/mysqladmin -u root -p password 'new-password'
 /usr/local/bin/mysqladmin -u root -h localhost -p password 
 'new-password'

 However, when I try the first command, it gives me the error:

 error: 'Can't connect to local MySQL server through socket
 '/tmp/mysql.sock' (2) although the mysqld dameon is running.

 When i try to execute the 'mysql' client it connects properly with the
 server but i am unable to execute any command from the client since I
 dont have a valid user id and password combination.

  So please let me know , how to set up a working root account for 
 mysql.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php