Monday, August 17, 2015

Is it OK to have database name the same as user name in MySQL?

Many web services require a database and quite often that is MySQL. Typically, the installation instruction of the software tells you to create a database and a user with permission for that database.




Is it OK to name the user and the DB the same?



For example, I am installing Openfire right now and I created a MySQL database "openfire" and MySQL user "openfire". Should I expect any problems? What is the convention?

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...