- #MYSQL CREATE USER QUERY OK 0 ROWS AFFECTED UPDATE#
- #MYSQL CREATE USER QUERY OK 0 ROWS AFFECTED PASSWORD#
It is necessary to have both ( % and localhost) accounts for your myuser to beĪble to connect from anywhere as myuser.
You have an anonymose user for localhost and that anonymous user don't have any password.
#MYSQL CREATE USER QUERY OK 0 ROWS AFFECTED PASSWORD#
UPDATE: Posting contents from the er table, as requested in the comments: mysql> select User, Host, Password from er so not only did the password fail to persist, but the privileges that I set were lost too.ĭoes anyone know what I'm missing here? Thanks! Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. However, I CAN login by simply pressing without a password: ~$ mysql -u myuser -p
When I try to login using the password, I get an error: ~$ mysql -u myuser -pĮRROR 1045 (28000): Access denied for user (using password: YES)
The user is created, but its password and privileges are not "sticking". Mysql> grant all privileges on MY_DATABASE.* to identified by 'mypass' | GRANT ALL PRIVILEGES ON `myfamily`.Connecting to MySQL through the command-line client as "root", I am trying to create a MySQL user with the following commands: mysql> create user identified by 'mypass' Mysql> GRANT ALL PRIVILEGES ON myfamily.* TO OK, 0 rows affected (0,02 sec) Mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY '' Mysql> DROP USER OK, 0 rows affected (0,02 sec) Thanks for now.ġ I did the following along your suggetion: I wonder why it would be different by doing user creation in one step vs. I have only used it for a short time but it works across restarts of mysql and apache2, so I am hopeful. It seems that using your one-step user creation works, as opposed to the two-step method I used, which has worked on previous occasions. I could of course just use the root user, but it seems that would not be a best practices way of dealing with security. Sometimes I get it to work, but after a reboot, it fails. GRANT ALL PRIVILEGES ON myfamily.* TO also added FLUSH PRIVILEGES after GRANT, and restart etc.
#MYSQL CREATE USER QUERY OK 0 ROWS AFFECTED UPDATE#
UPDATE er SET plugin='mysql_native_password' WHERE User='admin' I tried the following:ĭROP USER USER IDENTIFIED BY 'password' I am a very novice MySQL man so help would be appreciated. I have a feeling that it may some privilege issue I dont understand. I can use the root user without problems. I tried to delete and then re-add the user, and sometimes it works and sometimes not. RuntimeException: SQLSTATE Access denied for user (using password: YES) webtrees worked just fine - until a reboot. I created a database "myfamily" which is the one used by webtrees, a MySQL user and granted ALL privileges to the admin user. After a system reinstall and restore from backup all seemed to be well.
0 kommentar(er)
