Easy PHP and mysql ..php cannot see database on local pc (all works on server)

Question

I have a website written in php and mysql (written by someone else) and I need to alter it- just for your interest it is bridgetjonesart.co.uk. So I thought I would download it to my desktop pc and use easy php and mysql locally to make changes then upload it again.

I seem to have downloaded everything okay. I first just tried to run existing php using Easy Php and got

Warning: mysql_connect(): Access denied for user 'runningc'@'localhost' (using password: YES) in C:\Program Files (x86)\EasyPHP-12.1\www\backup from runningc\public_html\bridgetjonesart.co.uk\mysqlLogin\mysql_connect.php on line 6
Could not connect to database. Error

I have the sql database as a file 'runningc_bjart.sql' in the root directory but I think the php cant see it so I tried to use easy php administration, phpmyadmin and thought perhaps I should import the 'runningc_bjart.sql' file. So I tried and got an error message ...

Error
SQL query:

--
-- Table structure for table `Blog`
--
DROP TABLE IF EXISTS  `Blog` ;


MySQL said: Documentation

#1046 - No database selected

I am not sure what to try next, any help would be really appreciated. Thank you. Bridget

Marc B · Accepted Answer · 2013-08-13 15:56:27Z

2

The error messages are VERY clear.

Error #1: You're using the incorrect credentials, or have forgotten to grant rights on your database to the credentials you're using.

Error #2: You've forgotten to set a default database, so MySQL has no idea which database it should be looking in for the table you're trying to drop.

e.g. you need

mysql_select_db('mydatabase');

or change your DROP query to be

DROP TABLE mydatabase.Blog;

answered Aug 13, 2013 at 15:56

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Eduard · Accepted Answer · 2013-08-13 15:59:13Z

0

With phpmyadmin, create a new database named runningc_bjart and import the file there. Then search in your project for a config file where the db password is set and change it with your local mysql password

answered Aug 13, 2013 at 15:59

Eduard

3,6711 gold badge22 silver badges27 bronze badges

1 Comment

Bridget Jones Over a year ago

This was v useful... config file sorted as is db set up ... still having trouble importing ... see new question posted. Thanks Ed

Collectives™ on Stack Overflow

Easy PHP and mysql ..php cannot see database on local pc (all works on server)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related