How do i create a MySQL database and user? (lxadmin / kloxo)

How do i add a MySQL datbase / user?  (kloxo / lxadmin)

 

Creating/Removing databases

To create a new database,

go to the "Domains" page under "Client Home" and click your domain name.
Now click the "MySQL Databases" icon



In the next page, click on the "Add MySQL Database" tab on the top



In the next page, enter the database name and password (twice for confirmation). Click "Add" to create the new database.



Note: Please note that the user for the a mysql database is the same as the mysql db, and also that the domains name is always prefixed at the beginning. So if you add a 'string' mydb, to a domain 'domain.com', the actual database would be domainco__mydb, and user also would be domainco__mydb

So to access the database domainco__mydb, you have to use the same user domainco__mydb, and the password you have supplied.

 


 

Adding users to a database

Please note that the user for the mySQL database is the same as the mySQL database name

So if your database is called: domainco__mydb, then the user also would be domainco__mydb.

  • 124 Users Found This Useful
Was this answer helpful?

Related Articles

Accessing the control panel (lxadmin / kloxo)

Accessing the control panel There are several ways to access LXadmin:...

Accessing Web Mail (kloxo / lxadmin)

Accessing Webmail To access Webmail, login to the Webmail installation in the following format:...

Directory Structure in lxadmin / kloxo

Directory Structure Lxadmin has the following Directory structure for a Domain account: By...

How can i use InstallApp in kloxo?

InstallApp is disabled by default in kloxo web control panel due to making the template large....

How do i access Phpmyadmin? (lxadmin / kloxo)

Accessing PHPmyadmin To access phpmyadmin, go to the "Domains" page under "Client Home" and...