You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I added a website with sudo lamp add, I entered y for create db and user with same name, then I entered my sql root passwd and the name and password for the new db and user. Before printing db and user created successfully, it printed this error:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'websitePasswordsqlTheQuickBrownFox3569'' at line 1
I found the lines that create the error are located in /bin/lamp starting with line 224
I got around this error by creating 2 users for the db in phpmyadmin. One with localhost and the other with 127.0.0.1 both with same passwords, same usernames and default values for the rest (including all privileges on {dbname} )
The text was updated successfully, but these errors were encountered:
I added a website with
sudo lamp add
, I enteredy
for create db and user with same name, then I entered my sql root passwd and the name and password for the new db and user. Before printing db and user created successfully, it printed this error:ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'websitePasswordsqlTheQuickBrownFox3569'' at line 1
I found the lines that create the error are located in /bin/lamp starting with line 224
I got around this error by creating 2 users for the db in phpmyadmin. One with localhost and the other with 127.0.0.1 both with same passwords, same usernames and default values for the rest (including all privileges on {dbname} )
The text was updated successfully, but these errors were encountered: