No mysql Database ?

[rossmcglone]

hi,

Just a bit lost in what to do next.

(i have read other post on this issue and they all basically say that mysql is installed to another directory.)

ALL i have done is installed Mysql to C:\mysql

I started mysql, from command prompt
(c:\mysql\bin\mysqld --console)
mysql is running.

Then i did (c:\mysql\bin\mysqlshow)
it comes up with this
+------------+
| Database |
+------------+
| Test |
+------------+

and i think it is ment to look like this
+------------+
| Database |
+------------+
| MySQL |
| Test |
+------------+

I think this means there is no database "mysql". is there ment to be a database all ready or do i need to create it, and how do i do this.

Thanks in Advance.. Ross

 

[KarveR]

read the readme that comes with the mysql install. Its all very well documented, really

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[nego78]

i think that c:\mysql\bin\mysqlshow doesn't have appropriate privileges to use mysql database

http://www.robart.pl

 

[airidh]

You need to be logged in to mysql as root in order to see the mysql database.

 

[sedj]

from a dos command prompt, go to the bin directory, and then run "mysqlc".

Then type "use mysql".
Then type "show tables;"

You should see this :

C:\MySQL>cd bin

C:\MySQL\bin>mysqlc
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.0.15-nt

Type 'help' for help.

mysql> use mysql
Reading table information for completion of table and column names

Database changed
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv    |
| db              |
| func            |
| host            |
| tables_priv     |
| user            |
+-----------------+
6 rows in set (0.01 sec)

mysql>

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[rossmcglone]

Thank you all for your comments, i think it is a permisson problem, becuase when i follow "sedj" instructions i type "use mysql" and it comes back with
ERROR - access denied for user: '@localhost' to database 'mysql'
but how do i change permission on the database??

 

[KarveR]

well log in as a user (e.g. the root user) ... mysql -u root ( and if you've set up a password ,add -p)
mysql -u root -p
you'll then be prompted for the password.

Of course, all of this is in the documentation. including, how to set the root password, how to access mysql, and how to grant permissions.

Its quicker to read those docs than try to shortcut them, as some sections don't apply to certain installs.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.