MySQL installation no error but doesn't work.

[jdleung]

PP works well on my pc, yesterday I copied the whole site to my laptop.

the laptop also installed the same server,mysql,php.

but pp cannot get the database. shows "connect DB error: Access denied for user :'jdleung@localhost'(Using Password: YES) Cause #2

I checked the database with c:/mysql/bin/mysqlmanager.exe,and found a database "test",no other else displayed though there are some folders in c:/mysql/data/

c:/mysql/data/
---pixelpost
---test
---mambo
---bbs

in my pc I just copy a database folder such as "pixelpost15" to c:/mysql/data/
the database is soon displayed when browse with sqlmanager.exe

the most important is that mysql is running with green light.

I tried to install new pp, it still refused to work.

[Connie]

did you edit the pixelpost.php in order to have it working with the database at your Laptop?

did you start the server and the database at your laptop before running PP?

[jdleung]

all run in normal as they run in my pc. and the dir of apache,php,mysql are the same with my pc.

I check that php,apache run well.

I wonder why mysql display only a database "test", I think here is the solution.

[Connie]

you should either create a new database or use "test" as databasename in pixelpost.php

$pixelpost_db_pixelpost = "test"; // database

[GeoS]

Did you put correct access rights for user 'jdleung' connecting from host 'localhost' to DB 'test'?
After this you must to remember to flush MySQL server.

[jdleung]

Did you put correct access rights for user 'jdleung' connecting from host 'localhost' to DB 'test'?
After this you must to remember to flush MySQL server.


GeoS, you're right. I test the username and password: "root" and "".
it works.

so the winmysqladmin cannot show the database too.
but I'm confused, the username and password in my.ini are not the above.

how to change it?

Thx.

[GeoS]

Try to download MySQL Administrator. There is option for managing users - their logins, passwords, access rights, additional notes and much more.

Other way is to execute SQL statements:
http://dev.mysql.com/doc/refman/5.0/en/create-user.html
http://dev.mysql.com/doc/refman/5.0/en/grant.html

[eon]

Or install PHPMyAdmin. http://www.phpmyadmin.net/home_page/

[jdleung]

Or install PHPMyAdmin. http://www.phpmyadmin.net/home_page/

Thanks. phpmyadmin is the simple way.

but I'm still confused why the username and password don't match them in my.ini.

[GeoS]

my.ini in defaul contains password and login which you specified at installation process or root without password. There is no connection with additional users which you creat later.

[jdleung]

my.ini in defaul contains password and login which you specified at installation process or root without password. There is no connection with additional users which you creat later.

Thanks. GeoS.