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:
- Your username can only be up to 7 characters long, every character after that will be cut off.  
- You need to add your user to your database after the two are created.
- 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.

Was this answer helpful?

 Print this Article

Also Read

What is PHPSUEXEC?

When using the common PHP installation on a webserver, PHP runs as the user nobody and it...

What is HotLink Protection?

HotLink protection prevents other websites from directly linking to files on your website. Other...

What is SSH?

Secure Shell (SSH), known as Secure Socket Shell, is a UNIX-based command interface and protocol...

How do I change permissions on files and folders?

Login to your Control Panel at www.yourdomain.com/cpanel using your cPanel username and password....

Should I store a local copy of my website?

It is essential to keep a local copy of your website to protect it from any number of...