cPanel > MySQL is where you can make a database and then add with full permissions the user and password needed for wp-config.php, and then you can also specify in wp-config.php your table_prefix and it will be added within that database if not already present.
follow steps….
1. Cpanel in create user
2. Create datebase
3. Add full permissions this database and add user permission
4. After add wp-config.php file in this info
/* MySQL settings */
define( 'DB_NAME', 'database_name_here' );
define( 'DB_USER', 'username_here' );
define( 'DB_PASSWORD', 'password_here' );
define( 'DB_HOST', 'localhost' );
define( 'DB_CHARSET', 'utf8' );
/* MySQL database table prefix. */
$table_prefix = 'wp_';
Hi I also am having a problem installing my WordPress due to MySql. As my host im using freehostingnoads. When I create a database it groups them together so i create the user and the database together. It doesnt ask for the premissions to give to the user and it also has a string of numbers behind my name for the database name and my username. Ive put my info into the wp-config.php file with and without the string of letters with the correct password and it wont accept anything. When i put in my link to install word press it just shows a page saying “Error establishing a database connection” and says to make sure i have all my information in correct. I’ve tried it multiple times and nothing works.
On another note i can’t install it with the one press button because it installs an old version of wordpress and it wont let me update it.
Also if possible i really dont want to move hosts since i dont want to go through that trouble again.
So, if you have any clue on what i can do it would really be appreciated! Thanks!
I am new to WordPress. What is Cpanel? I can’t find it anywhere on my site or the WordPress site.
One important piece of the puzzle is having the correct host set in wp-config. Depending on your webhost, you may be able to use “localhost”, but this is not always the case.
Here’s a helpful link to possible DB_HOST values depending on webhost: https://codex.wordpress.org/Editing_wp-config.php#Possible_DB_HOST_values
If you are 100% positive you have the right username, password, and host in the wp-config file, and you are still not able to connect, there is probably an issue with the permissions of that database. Some hosting providers let you set database permissions to allow outside connections, and some will require you to contact them to do it for you. Your best bet in this situation is to contact your webhost to find out.
Deb Grantham – cPanel will not be on your site or WordPress, it is the backend of your site, and your webhost would have provided the login details for that. If you are having trouble with this, please create a new thread in the support forum or contact your hosting company.