 | | | Account Problems. Can 't register server with new account | Account Problems. Can 't register server with new account 2007-11-06 - By AlejandraB
Back
Thanks Russell for your help.
My user 'usuario1' did have the host='localhost' asigned.
It was kind of weird I couldn't enter back then. But today, days after and
not even entering the server ... I got in with user=usuario1 !
[root@(protected) bin]# ./mysql -u usuario1 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.27-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+-- ---- ---- ---- --+
| Database |
+-- ---- ---- ---- --+
| information_schema |
| pruebaCluster |
| test |
+-- ---- ---- ---- --+
3 rows in set (0.01 sec)
I wonder why .... (I'm using MySQL Cluster).
Russell E Glaue wrote:
>
> 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=lists@(protected)
>
>
>
--
View this message in context: http://www.nabble.com/Account-Problems.-Can%27t
-register-server-with-new-account-tf4744425.html#a13616486
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|