Title: same user in PHPMyAdmin for different localhost sites Last modified: November 28, 2019 --- # same user in PHPMyAdmin for different localhost sites * Resolved [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/) * I have 4 installations on the same localhost – all with different names (e.g. 1, 2, 3 and 4) and have established the databases for each, however – when for the individual site, I can not use the same username and password (comes up with an error second time I try to saying “‘Lars’@’localhost’ already exist! Is there a way that I can have the same username and password on all my WordPress sites– in PhPMyAdmin as well as for the WordPress login for all the sites? Viewing 12 replies - 1 through 12 (of 12 total) * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186210) * Are you adding the user or just giving that user permissions in another DB? Those are two different things. * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186303) * 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! * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186357) * 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' ``` * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186669) * 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: [http://localhost/byemery](http://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? * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186842) * You din’t set a password. The FIRST line should have been * GRANT ALL on byemery.* to ‘Lars’@’localhost’ IDENTIFIED BY ‘yourpassword’; * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186955) * 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 6 years, 6 months ago by [Lars.Lemming](https://wordpress.org/support/users/larslemming/). * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12186959) * BTW Steve, thank you for your assistance, help and commitment – and that even on Thanksgiving, happy thanksgiving to you and your nearest * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187468) * Did you put a semicolon at the end of the statement? * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187517) * 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’; * Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/) * (@sterndata) * Volunteer Forum Moderator * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187536) * 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. * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187948) * 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 * Thread Starter [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * (@larslemming) * [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187950) * Considered solved Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘same user in PHPMyAdmin for different localhost sites’ is closed to new replies. ## Tags * [multiple wordpress installations](https://wordpress.org/support/topic-tag/multiple-wordpress-installations/) * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * [user](https://wordpress.org/support/topic-tag/user/) * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) * 12 replies * 2 participants * Last reply from: [Lars.Lemming](https://wordpress.org/support/users/larslemming/) * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/same-user-in-phpmyadmin-for-different-localhost-sites/#post-12187950) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics