. I'm tuning
it.
Stephen Liu
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9728432
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
--- 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
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
--- 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
[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
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
--- 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:
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.
`cat /mysql-data-directory/host_name.pid`
mysqld_safe –skip-grant-tables
mysqladmin -u root flush-privileges password “newpassword”
OR is there any other way to fix this problem. TIA
B.R.
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password
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
this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9712041
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
.log.old
* end *
Read /var/log/mysql.log
Can't find anything related.
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9713069
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
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
34
070328 23:56:09 [Note] /usr/libexec/mysqld: Shutdown complete
070328 23:56:09 mysqld ended
* end *
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9717062
Sent from the MySQL - General mailing list archive at Nabble.com
;
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
* end *
Still failed
satimis
--
View this message in context:
http://www.nabble.com/Problem-on-creating-root-password-tf3479106.html#a9726511
Sent from the MySQL - General
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
17 matches
Mail list logo
