> I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After
> installing when enter into mysql it gives me message " Access denied for
> user [EMAIL PROTECTED] host .......using password yes"
>
> i have tried all the options like
>
> #mysql -u root -h localhost
> #mysql -u root -h localhost -p
> #mysql -u root -h localhost -p mysql
> #mysql -u root -h localhost test -p
> #mysql -u root -h localhost  test
> #mysql -u root
> #mysql -u root mysql
>
> but none of the option is working  at all.
>
> Please any idea how i can change the root password or enter the mysql
after
> fresh installation


First disalbe the root passwd:

To remove password simply type:
# mysqladmin -p password ''
Enter password:
#

It will ask the passwd, enter the password you set previously,

After that you can run mysql binary. I will not show any error messages and
you can play with mysql.

# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.54-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

thanks
--mathan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to