error in the mysql and settings.php
Hi
I am new to the drupal and I am trying to install drupal. I am getting an error as " The MySQL error was: Can't connect to MySQL server on '127.0.0.1' (10061) ".
I have installed
the mysql and apache 2.2 on my local Vista machine and the project is in the htdocs folder of the apache, but I cant find the reason for this error, the mysql installation is fine and it is running fine on the port 3307, but dont know why it cant communicate to the mysql installation. Further the error also says :
"Currently, the username is root and the database server is 127.0.0.1.
* 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?"
Any clarification is highly appreciated.
Thanks.
Have you make database? And
Have you make database? And have you changed file sites/default/settings.php on line 92?
$db_url = 'mysql://username:password@localhost/databasename';
Yes, but what is make database ?
yes i did, i made the change to that line but I dont understand by the term "make database" ? Could you please explain me that ?
-S.G.
In your phpmyadmin , you need
In your phpmyadmin , you need to create database for your site. That means that you need to go to phpmyadmin page. Found field that says "Create new database". Fill that field with the name you want, and click create button. Then that name you need to enter instead of "databasename" in settings.php. And after that you need to go to url: yoursite/install.php
I resolved the problem
I resolved the problem, there was a problem with my MySQL installation, the 2 out of 3 default databases for the mysql were missing, so I had to uninstall the mysql and manually remove the directory from the Program files and then install again, and it is working fine now.
Thanks anyways.
-S.G.