same user in PHPMyAdmin for different localhost sites

Are you adding the user or just giving that user permissions in another DB? Those are two different things.

I have one site I am working on (1), and need to start on 3 new sites (2, 3 and 4).
I then place WordPress in each of these folders.
In htdocs I already have folder 1, and create folder 2, 3 and 4.
I then change the name of the “wp-config-sample.php” document for each of the new folders/sites, open it, change as follows;
define(‘DB_NAME’, ‘2’); (and 3 and 4)
define(‘DB_USER’, ‘Lars’);
define(‘DB_PASSWORD’, ‘MY-PASSWORD’);
and leave define(‘DB_HOST’, ‘localhost’); as is.
I then go in to PhPMyAdmin and create 3 new databases (1 is there already with DB_USER being “Lars” and DB_PASSWORD being “MY-PASSWORD)
When I try to establish user for site 2, I get the message “‘Lars’@’localhost’ already exist!” (translated from Danish to English).
So the question is, how can I use the same username and password for all 4 websites, as long as they are on my localhost (it will be changed when I upload to live server)?
I hope this explains the situation better!

You can. Don’t create a new user for DBs 2,3, and 4. Just give 'Lars'@'localhost' privs on those databases.

From the SQL tab:

GRANT ALL on DB2.* to 'lars'@'localhost'
GRANT ALL on DB3.* to 'lars'@'localhost'
GRANT ALL on DB4.* to 'lars'@'localhost'

Hmm – Steve Stern, luckily I took a backup of the database for my existing project, as I deleted them all to start over.
First I created the 4 new databases (byemery, energreen, flexsolution and hjertestarterekabe).
Then go press the SQL tab to enter – precicely:
GRANT ALL on byemery.* to ‘Lars’@’localhost’;
GRANT ALL on energreen.* to ‘Lars’@’localhost’;
GRANT ALL on flexsolution.* to ‘Lars’@’localhost’;
GRANT ALL on hjertestarterskabe.* to ‘Lars’@’localhost’;
(these are the actual titles of the 4 sites I am working on – not 1, 2, 3 and 4)
Once this is done, I close down the PHPMyAdmin page, open a new webpage and enter:
https://localhost/byemery
Here I expect to start setting up the WordPerfect installation – but run into a page which says “Error connecting to the database”!
Can you see what I do wrong?

You din’t set a password. The FIRST line should have been

GRANT ALL on byemery.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘yourpassword’;

Hmmmmm – when I do that, I get the following error message:
Error
SQL query:

GRANT ALL on byemery.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘mypassword’
MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘‘mypassword’’ at line 1

The password ‘mypassword’ is naturally replaced by my actual password, but I do not want to put that out here – you never know ??

Any ideas?

• This reply was modified 5 years, 3 months ago by Lars.Lemming.

BTW Steve, thank you for your assistance, help and commitment – and that even on Thanksgiving, happy thanksgiving to you and your nearest

Did you put a semicolon at the end of the statement?

Yes, with the exception of the password, this is EXACTLY the statement I enter:
GRANT ALL on byemery.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘MyPassword’;
GRANT ALL on energreen.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘MyPassword’;
GRANT ALL on flexsolution.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘MyPassword’;
GRANT ALL on hjertestarterskabe.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘MyPassword’;

No. The only time you add “identified by” is when you either explicitly create the user or implicitly by giving privs *for the first time*. Once you’ve given a user a password, you don’t do it again.

Ahh – Got it, I have now created the user and password for the energreen site manually under the Privileges tab and then in the SQL tab added:
GRANT ALL on byemery.* to ‘Lars’@’localhost’;
GRANT ALL on flexsolution.* to ‘Lars’@’localhost’;
GRANT ALL on hjertestarterskabe.* to ‘Lars’@’localhost’;
and that seems to work – at least I have not gotten any errors!
Thank you ever so much Steve Stern for your help

Considered solved