Kloxo : MYSQL database user question

485 views
asked May 7, 2012 in Database by darkshark (1,500 points)
Hi

I have 4 dayabases that I want to create using Kloxo but I don’t want to create new db-user for each database. Can I have only one mysql user for all my databases and give it all privileges that would enable it to manage all 4 databases?
Appreciate your advice
thanks

2 Answers

0 like 0 dislike
answered May 7, 2012 by FixHost (12,380 points)
Using one mysql user for all dbs is definitely is not a good idea, because, if one site will be compromised then all databases will be compromised as well.
0 like 0 dislike
answered May 7, 2012 by lionhost (4,060 points)
This is possible in most control panels. you can also do it by setting permissions as the mysql root user.
...