Find answers to your questions

Documentation

How to Create a Database in MySQL

  • 0

1. Click on the MySQL icon. You can create a database via your control panel by clicking on the MySQL icon. Here is a link to some information that may be helpful in setting up a database: http://www.cpanel.net/docs/cpanel/

2. Scroll down to the MySQL menu.

3. Create the database. When you create the database you are able to choose the name which then becomes the name of your database. Your username will be added to it so that the full database name will be username_dbname.

You will also need to create a database username and password under MySQL. The dbusername is limited to 8 characters. Your username will be added to it so that the full dbusername will be username_dbusername.

4. Add the User. You then add this user to the database you created and it should then give you some connection strings for Perl and Php. To add the user, select the user in the drop-down list and select the database in the other drop-down list. Then click the Add User to DB button under it.


If you still have questions about MySQL databases, please contact us by opening a support ticket or by using our live chat feature.

Related Articles

How to empty my DNS cache Overview Your DNS cache stores the locations (IP addresses) of web servers that contain web pages which you have recently viewed. If the location of the web server changes before the entry in your DNS cache updates, you can no longer access the site. If you encounter a large number of HTML 404 error codes, you... What is cPanel? cPanel is a control panel with which you can manage almost any element of your cPanel hosting account. The interface is very easy to use - cPanel works constantly to improve the platform by staying on the cutting edge of technology as well as constantly updating its various security measures, making it... How cPanel & WHM Improved Email Hosting cPanel and WHM have gone through some serious upgrades to their Email Hosting features throughout the versions. Just in the past 2 years, the cPanel team have made it easier than ever for web hosting providers, system administrators, and all other cPanel users to be able to host email accounts. ... CURL: could not resolve host: cpanel.net Error: curl: (6) Could not resolve host: securedownloads.cpanel.net; Unknown error Fix: Edit: nano -w /etc/resolv.conf Add the following lines: nameserver 8.8.8.8 nameserver 8.8.4.4 If you still have questions or concerns, feel free to contact us by opening a support ticket or with... How can I activate my paid license after a trial? You can do this by running this command in SSH: /usr/local/cpanel/cpkeyclt It should look something like this: [root@cpanel home]# /usr/local/cpanel/cpkeyclt Updating cPanel license...Done. Update succeeded. Building global cache for cpanel...Done [root@cpanel home]# If you still have...