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 ! [EMAIL 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. >> >> [EMAIL 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/[EMAIL 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/[EMAIL PROTECTED]
