Adding DB finctionality on web server only

Hi all,

I got on a multi server setup a web server which now I want to add to it Mariadb in order to work as a db server too.
What is the proper way to achieve this?
I assume that I have to install the mariadb packages first and then re-run the update.sh script?

 

Hi Till, I did what you mentioned and is adding fine the DB and the user but once I try to login with the user credentials it doesn't work at all; The DB does not appear under the user at all.
If I log in with a root user I can see the database.

Any ideas?

 

I've added the user via the ISPconfig interface and asign it to a new db.
Then I logged in as root user on phpmyadmin and import the db. Then I logged out and tried to login with the user and getting authentication error.
I logged in afterwards directly to the server with ssh and into mysql (mysql -u username -p) and worked fine but there are no databases at all there; show databases; query returns nothing.

 

Also forgot to mention that the user is there with USAGE privileges but is not assigned to the DB.

 

ok I've done that and I can log in with the user but there is no database displayed in phpmyadmin.
The database is however there if I logged with any other account that has root access.

 

I'm getting in logs that user is denied eventhough the password is correct. That is under logs when it tried to sync/add the db.
Can you share please the proper queries that I have to run to the master(who holds the phpmyadmin and the controlpanel) and the server which I'm trying to add the database? Just to check with those that I got in place as it should be working without a problem but it doesn't; it doesn't create at all the db.

Code:

Unable to connect to mysql: Access denied for user 'myuser'@'localhost' (using password: YES)