How do I create a database in MySQL?

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 with setting up a database.

Go to http://www.cpanel.net/docs/cpanel/ and scroll down to the mySQL menu.

When you create the database you choose the name. This 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 database username and password under MySQL. The dbusername you input is limited to 8 characters. Your username will be added to it so that the full dbusername will be username_dbusername. 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.

  • 191 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Related Articles

How do I set up my PC to connect to MSSQL Server database at Webcom Systems Web Hosting?

Setting up your PC to connect to your SQL Server database at Webcom Systems Web Hosting is...

What are the connection settings for my MySQL database?

The hostname to connect to is "localhost" if connecting from a script on the server, or your...

Can I have oracle database support on Windows 2003 Server?

No. As of now we do not have oracle on Windows Server.

How do I connect to my database from Dreamweaver MX?

We're going under the assumption that you have already set up a MySQL database on your server....

How do I connect to MS ACCESS Database on Windows 2003 Server ?

Upload your MS Access database on the root folder. Create a System DSN and give the Access mdb...