I have just set up my second virtual host and it works. Now I want to install a second Wordpress site following the mysql from this tut:
Since I already have one site up and running on my first virtual host I only want to create a database and user for my second Wordpress site.
CREATE DATABASE SecondDatabase;
CREATE USER SecondUser@localhost;
SET PASSWORD FOR SecondUser@localhost= PASSWORD(“SecondPassword”);
ERROR 1064 (42000): 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 ‘SecondPassword’’ at line 1
I have mysql Ver 8.0.23.
Then I tried:
CREATE USER ‘SecondUser’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘SecondPassword’;
GRANT ALL ON SecondDatabase.* TO ‘SecondUser’@‘%’;
Wordpress site is not up and I’m afraid I have messed up my mysql users and databases.
I have changed the wp-config.php so it matches the mysql database, user and password names.
Any help on how to solve this will be greatly appreciated, thanks!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!