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]
