> It looks like you can log in to the mysql client as root. Do you have
> permission to change the password once you're logged in?
>
> [EMAIL PROTECTED] jusoz]$ mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor...
>
> mysql>USE mysql;
> Database changed.
>
> mysql>UPDATE user SET Password = PASSWORD( 'xxxx' ) WHERE User =
> 'root'; Query OK, 0 rows affected (0.03 sec)
> Rows matched: 2 Changed: 0 Warnings: 0
>
> mysql>FLUSH PRIVILEGES;
> Query OK, 0 rows affected (0.05 sec)
>
> mysql> quit;
>
> Then see if logging in as expected works:
> [EMAIL PROTECTED] jusoz]$ mysql -u root -pxxxx
>
> Wes
Hello Wes,
thanks for your aid. I have the access denied... :
[EMAIL PROTECTED] jusoz]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21 to server version: 4.0.18
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'
I can access to the databae mysql as another user, "jusoz". Then i can
play the steps as you sugest, but when i log as "root" all is the same:
[EMAIL PROTECTED] jusoz]$ mysql -u root -pxxxx
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
**These are the databases i can access ->
[EMAIL PROTECTED] jusoz]$ mysqlshow -u root
+-----------+
| Databases |
+-----------+
| test |
+-----------+
[EMAIL PROTECTED] jusoz]$ mysqlshow -u jusoz
+--------------+
| Databases |
+--------------+
| backup_mySQL |
| datos-mySQL |
| mysql |
| test |
| tmp |
+--------------+
Thanks for your sugestions,
jose.
--
Jose Usoz / Cromosfera
http://www.cromosfera.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
