 | | | Subject: Re: Account Problems. Can 't register server with new account | Subject: Re: Account Problems. Can 't register server with new account 2007-11-06 - By Russell E Glaue
Back
Run this SQL Query
mysql> select Host,User from user;
Make sure the output has this record values:
+-- ---- ---+-- ---- --+
| Host | User |
+-- ---- ---+-- ---- --+
| localhost | usuario1 |
+-- ---- ---+-- ---- --+
If your mysql error message were to say this:
Access denied for user 'usuario1'@'me-me-me.com'
The record values need to look like this:
+-- ---- ------+-- ---- --+
| Host | User |
+-- ---- ------+-- ---- --+
| me-me-me.com | usuario1 |
+-- ---- ------+-- ---- --+
Or
Access denied for user 'usuario1'@'192.168.20.5'
+-- ---- ------+-- ---- --+
| Host | User |
+-- ---- ------+-- ---- --+
| 192.168.20.5 | usuario1 |
+-- ---- ------+-- ---- --+
To Update:
mysql> update user set Host="localhost" where User='usuario1' LIMIT 1;
-RG
AlejandraB wrote:
> Good evening.
>
> I have mysql cluster installed and I'm trying to start the mysql server with
> a new user account recently created, and I'm having trouble accessing the
> server with the new account.
>
> [root@(protected) bin]# ./mysql -u usuario1 -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'usuario1'@'localhost' (using
> password: YES)
>
>
> The new user does exists and I know the problem is not password related.
>
> mysql> use mysql
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select User from user;
> +-- ---- --+
> | User |
> +-- ---- --+
> | mysql |
> | root |
> | usuario1 |
> | |
> | mysql |
> | root |
> +-- ---- --+
>
>
>
> Thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|