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)
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)
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.
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 ?
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.
Make sure to limit this user connection from localhost only.
ASKER
it has been set already, Should I remove the password right now ?
Tks
Tks
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
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks