On 6/7/06, Brian D. McGrew <brian@xxxxxxxxxxxxx> wrote:
> I am getting [root@saabworld default]# mysql Welcome to the MySQL
> monitor. Commands end with ; or \g.
> Your MySQL connection id is 14 to server version: 3.23.54
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use mysql
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
> mysql>
>
> How do i rectify this
----
[root@saabworld default]# mysql -u root -p <cr>
Now MySQL should prompt you for the root password.
:b!
Brian D. McGrew { brian@xxxxxxxxxxxxx || brian@xxxxxxxxxxxxxxxxxxx }
--
> This is a test. This is only a test!
Had this been an actual emergency, you would have been
told to cancel this test and seek professional assistance!
--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Hi Brian
I accidently deleted root user pointing to localhost entry from user
table in the mysql table
How do i set it back again
Now I get
[root@bdc31096e default]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql> exit
Bye
[root@bdc31096e default]#
Thanks Again
Kaushal
