Re: Problem on creating root password

2007-03-29 Thread satimis
Typing either mypassword or YES prompted; mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' * end * That is asking for your *old* password. [/quote] I did not create password before. This is a new installation.

Re: Problem on creating root password

2007-03-29 Thread Stephen Liu
--- Chris [EMAIL PROTECTED] wrote: Retried as follows; [EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword Enter password: Typing either mypassword or YES prompted; mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user

Re: Problem on creating root password

2007-03-29 Thread Chris
satimis wrote: Typing either mypassword or YES prompted; mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' * end * That is asking for your *old* password. [/quote] I did not create password before. This is a new

Re: Problem on creating root password

2007-03-29 Thread Stephen Liu
--- Chris [EMAIL PROTECTED] wrote: - snip - Try this: mysqladmin -u root password xyz That will change your password to 'xyz'. Before received this email I tried; [EMAIL PROTECTED] ~]# mysqladmin -u root -p mysqladmin Ver 8.41 Distrib 4.1.20, for redhat-linux-gnu on x86_64 Copyright

Re: Problem on creating root password

2007-03-29 Thread Chris
[EMAIL PROTECTED] ~]# mysqladmin -u root password xyz mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' * end * So you *have* set the root password before. From your previous emails: # mysqladmin -u root password

Re: Problem on creating root password

2007-03-29 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], satimis [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart Stopping MySQL: [FAILED] Starting MySQL:[ OK ] Ok, lets try it a different way, using only the

Re: Problem on creating root password

2007-03-29 Thread Stephen Liu
--- Chris [EMAIL PROTECTED] wrote: - snip - So you *have* set the root password before. From your previous emails: # mysqladmin -u root password yourrootsqlpassword That set the password to yourrootsqlpassword. If you need to reset it, see documentation:

Re: Problem on creating root password

2007-03-29 Thread Duncan Hill
On Thursday 29 March 2007 11:38:21 Stephen Liu wrote: http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html I tried learning resetting the password according to above URL. I can't find set command on this box. I don't know which package provides it so finally I surrendered.

Re: Problem on creating root password

2007-03-28 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], satimis [EMAIL PROTECTED] wrote: Pls advise how to locate mysql=E2=80=99s hostname.pid file? Try looking in standard directories such as: /var/run/mysqld or /var/run/mysql or /var/run The filename can be in form of 'hostname.pid', but it will rather be named

Re: Problem on creating root password

2007-03-28 Thread satimis
Hi Maciej Dobrzanski, This is a new installation. I'm now tuning MySQL. [quote] Try looking in standard directories such as: /var/run/mysqld or /var/run/mysql or /var/run The filename can be in form of 'hostname.pid', but it will rather be named 'mysqld.pid'. [/quote] [EMAIL PROTECTED] /]#

Re: Problem on creating root password

2007-03-28 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], satimis [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables [1] 5119 [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070328 19:39:12 mysqld

Re: Problem on creating root password

2007-03-28 Thread satimis
Hi Maciej, [quote] See the error log for details of why the server stopped. It is usually located either in /var/log (or its subdirectories, such us /var/log/mysql) or in mysql data directory, which in your case is /var/lib/mysql. The error log filename pattern is 'something.err'

Re: Problem on creating root password

2007-03-28 Thread Maciej Dobrzanski
In news:[EMAIL PROTECTED], satimis [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] /]# mysqld_safe =E2=80=93skip-grant-tables [1] 5119 [EMAIL PROTECTED] /]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070328 19:39:12 mysqld

Re: Problem on creating root password

2007-03-28 Thread satimis
Hi Maciej, [quote] Try running mysqld_safe with additional parameter: --log-error=/var/lib/mysql/my.err. Then check what has been written into that file.[/quote] [EMAIL PROTECTED] ~]# kill `cat /var/run/mysqld/mysqld.pid` No complaint [EMAIL PROTECTED] ~]# /etc/init.d/mysqld restart Stopping

Re: Problem on creating root password

2007-03-28 Thread satimis
Hi Maciej, I found that I made a mistake from the beginning # mysqladmin -u root password yourrootsqlpassword leaving out -- before password Retried as follows; [EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword Enter password: Typing either mypassword or YES prompted;

Re: Problem on creating root password

2007-03-28 Thread Chris
Retried as follows; [EMAIL PROTECTED] ~]# mysqladmin -u root --password mypassword Enter password: Typing either mypassword or YES prompted; mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' * end * That is asking