How to change wordpress database connection
hello,
Mysql 4.1.16 running.
But can not install Wordpress, Wordpress, the possible errors:
Error establishing a database connection
This either means that the username and password information in my wp-config.php file is incorrect or we can not contact the database server at localhost. This could mean your host's database server is down.
Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
However, all 3 correct, I think.
The only problem that could be is that what I have here putter with Mysql. install, uninstall etc.. But now run all servers but it does not work with Wordpress.
Hours searching for forums but found nothing!
Who can help me please?
Meanwhile, I notice that I wp-config.php can not edit because it owned by Mysql.
Re: How to change wordpress database connection
Try again in a new MySQL user to create specific to Wordpress. Then try with a new user connection. Possibly through another program such as phpMyAdmin or MySQL or Navicat.
If that fails, then there is something wrong with your MySQL configuration.
If only Wordpress that does not want to connect, you have the problem that search.
Re: How to change wordpress database connection
Moreover, the link you enter does not work for the outside world though.
yes I knew it. just what I tried.
I do not know but how can I create a new user in Mysql specifically for wordpress?
Can you tell me??
....
...
If I 'mysql' in the terminal type I get Welcome to the MySQL monitor ... and so on.
But if I type mysql-u root I have problems:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: NO)
to be honest I do not who what and how you Mysql for the first time. The creation of a database work but who can now consult the user stuff.
Re: How to change wordpress database connection
If you have installed MySQL, you have basically one user: root. It can connect from localhost without a password.
First you need a password to the root set, which has access to everywhere. If you prefer not terminalt use phpMyAdmin or Navicat (preferably the latter because no additional configuration work).
If you're logged in, you can create additional users. I make for each separate database / website / application a separate user. Here you can best use a GUI to TABLE SPECIFIC rights to, so no global privileges.
The error message you get is strange, especially if you say that you can create tables. Get on that table with the same application as the one the error?
If not, then I know another possible cause: the method of encrypting the user password. First look after the rest here before continuing.