MySQL database and user naming syntax

Since we run a shared hosting environment, we have to uniquely identify your usernames to your account only. We do this by attaching your system username and an underscore '_' before all the databases and users that you create. This only applies to your database name and database username, you password stays normal.

Please Remember Standard Syntax of MySQL database:

  • Your username should be up to 7 characters long, every character after that will be cut off. 

create new database cpanel

  • You need to add your user to your database after the two are created with the access privileges. Check ALL PRIVILEGES or manually check and grant permissions.
add new user mysql cpanel

manage user previleges cpanel

  • Database Server/Host Address- If your script or program is going to be accessing our database locally, meaning it is stored on your account, the server/host address will always be: localhost.
  • 0 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

Can I add an auto responder to my emails?

An auto responder can be setup in cPanel to respond to any incoming emails with a message...

Can I change my cPanel username?

Unfortunately our management system does not allow to change the username as the system uses your...

Can I execute shell exec() function on PHP or it is prohibited?

Shell exec() is supported on hostimed.com for all the services. But, support team can activate...

Can I set permissions to 777?

It is not recommended to change your permissions to 777 as other users on the server as well as...

Can I set up custom name servers?

A custom name server allows you to run your own name server to respond to DNS requests for your...