[StevieB]

Hi Guys, I'm probably being really dumb but I have a small problem.

Got MySQL installed and had a database for my forum called "myforumdb"

MySQLShow came up with
+---------------+
+ Databases +
+---------------+
+ myforumdb +
+ mysql +
+ test +
+---------------+

I'd wanted to install a blogger/chat script sorta thing n the php install file wasn't working kept saying couldn't create database or something
Me being stupid decided to create the database for it instead

Typed in
H:\mysql\bin\> mysql -u root -ppassword create test_db

It worked fine cos it came back to the dos prompt but now when I run mysqlshow I get

+---------------+
+ Databases +
+---------------+
+ test_db +
+---------------+

And now I can't get my forum all I get is cannot access database

In mysql if I do SHOW DATABASES it shows the 3 databases as it did before with mysqlshow

I've now managed to get it to show which I'll just say is progress )
+---------------+
+ Databases +
+---------------+
+---------------+

Any Ideas?

[mikaelf]

for security reason, mysql password passed on command prompt would be neglected by mysql daemon. thus when you supply command prompt:
H:\mysql\bin\> mysql -u root -p password create test_db

you will be logged in as @localhost (read: nobody@localhost) and MySQL will output error: access denied for user @localhost or access denied for user root@localhost.

to create database using command prompt you are supposed to type using this syntax:
H:\mysql\bin\> mysql -u root -p create test_db
Enter password: your_mysql_root_password

And then:
H:\mysql\bin\> mysqlshow -u root -p
Enter password: your_mysql_root_password

As a test case, try to supply the command prompt with:
H:\mysql\bin\> mysqlshow