mysql administrator in linux
hi all, i got problem to create a user mysql account, when i type in the command prompt "mysql --user=root mysql" it keep saying " ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) "
|
Quote:
|
it ask me for the password!!i don't have it..what is the password ??" What i missing here ?. Do i forgot something! can somebody give the proper/full command line..how to get into this ?? :)
|
Take a look at here:
http://stanton-finley.net/fedora_cor...tes.html#MySQL You should create initial password for root, anyway, link above will explain everything you need to start using mysql |
It say "Access denied for user 'root'@'localhost'". Why this is happen??.This is the example that
i go through ..step by step with the link above //////////////////////////////////////////////////////////////////////////////////////////////// [sys@xxxx ~]$ sudo su - Password: [root@xxxx ~]# cd / [root@xxxx /]# vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-innodb [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ~ ~ ~ ~ ~ ~ ~ ~ "/etc/my.cnf" 15L, 357C written [root@xxxx /]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) //////////////////////////////////////////////////////////////////////////////////////////// can you check it for me?? |
What distribution are you running? Is this on a computer you setup, or is this a hosting provider or a remote machine? It appears you are running as root, so I'd guess at least that you have actual root access to this machine. In a blindingly way off attempt to get in, I'd try your root password:
mysql -u root -p And enter your root password. Your other options are outlined on this page: http://www.alt-php-faq.org/local/70/ HTH Cool |
actually.. i'm controling the remote machine. I have try "mysql -u root -p", it ask me the password and then.. i enter my root password..but it keep saying .."ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)". What it means??
|
Use this to change your root password
Quote:
http://lists.mysql.com/mysql/171366 Works well for me, Mathieu |
Hello, i get the same thing so i thought there was no need to start a different thread.
When i try what 'mat087' suggested i get: Code:
root@:mysqld_safe --skip-grant-tables & I use Ubuntu server 6.06 RC. I am connecting trough ssh. in the /etc/mysql/my.cnf i tryed both with Code:
bind-address = 127.0.0.1 |
I really don't know what the problem could be...
Do you stop mysql server before doing anything ? Do you have anything else running that could be in conflict with mysqld_safe ? I don't know why you mentioned that you're connected through ssh. But just in case that it can help you, I'm connected through ssh too, and the line "bind-address = 127.0.0.1" is uncommented. Mathieu |
|
All times are GMT -5. The time now is 07:42 AM. |