Link to home
Start Free TrialLog in
Avatar of AXISHK
AXISHK

asked on

New user mySQL

My new created user in mysql can't access. Any idea ?

mysql> create user 'scigadm'@'localhost' identified by 'xxxxx'


mysql> select host, user from user;
+----------------+------------+
| host           | user       |
+----------------+------------+
| localhost      | sciadm    |
+----------------+------------+
29 rows in set (0.00 sec)

-bash-3.2# mysql -u scigadm -pxxxxx
ERROR 1045 (28000): Access denied for user 'scigadm'@'localhost' (using password: YES)
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Did you create a password for that user?
You need to list all, if this user is tied to a database, the database name is part of the authentication and must be included.
Avatar of AXISHK
AXISHK

ASKER

do you mean i need to grant permission to the user in mysql ?

How can I change the user account such that no password is asked for login ?
Do not set a password for the account and do not use the -p.

Make sure to limit this user connection from localhost only.
Avatar of AXISHK

ASKER

it has been set already, Should I remove the password right now ?

Tks
Avatar of AXISHK

ASKER

On more check, for the host field in Mysql\user table, will this field be matched with the host from the remote connection ? In case the userA is running on ServerA connect to mySQL on ServerA, will the user appear as usera@serverA in MySQL ?

Tks
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AXISHK

ASKER

Tks