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 surrende

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: > > http

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 th

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 yourro

Re: Problem on creating root password

2007-03-28 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 Co

Re: Problem on creating root password

2007-03-28 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-28 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 denie

Re: Problem on creating root password

2007-03-28 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 installati

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 ask

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 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 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

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' (hostname.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

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] /]# l

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 'mysq