i have problem in my connections on mysql, i try this in my fedora but if i start my fedora i cannot acces my mysql everytime i wanna connect i have found this message mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) this my configurations for acces mysql i try and this run, but if i connect to my MySQL i have that message like that ------------------------------------------------------------ [root@localhost suba]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [root@localhost suba]# /etc/init.d/mysqld stop Stopping MySQL: [ OK ] [root@localhost suba]# /usr/bin/mysqld_safe --user=root --skip-grant-tables & mysql mysql [1] 4454 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@localhost suba]# nohup: ignoring input and redirecting stderr to stdout Starting mysqld daemon with databases from /var/lib/mysql [root@localhost suba]# /usr/bin/mysqld_safe --user=root --skip-grant-tables & mysql mysql [2] 4504 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.67 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> nohup: ignoring input and redirecting stderr to stdout A mysqld process already exists mysql> use mysql; Database changed mysql> update user set Password=null where Host='localhost' and User='root'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 mysql> exit; Bye [2]+ Exit 1 /usr/bin/mysqld_safe --user=root --skip-grant-tables [root@localhost suba]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.67 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> exit Bye [root@localhost suba]# /etc/init.d/mysqld restart STOPPING server from pid file /var/run/mysqld/mysqld.pid 090218 11:49:03 mysqld ended Stopping MySQL: [ OK ] Starting MySQL: [ OK ] [1]+ Done /usr/bin/mysqld_safe --user=root --skip-grant-tables [root@localhost suba]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) [root@localhost suba]# ----------------------------------- i hope all can give me some way to this problem thanks so much before -- KLUG - Kendari Linux User Grup http://kendari.linux.or.id -- fedora-list mailing list fedora-list@xxxxxxxxxx To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list Guidelines: http://fedoraproject.org/wiki/Communicate/MailingListGuidelines
