View Single Post
  #1 (permalink)  
Old June 27th, 2004, 08:21 AM
nusrati nusrati is offline
Authorized User
Join Date: Jun 2004
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem creating database

I am very new to MYSQL.

I. installed MYSQL on W2k sever from MYQSL website. I am using a book to learn MYSQL.

2. after installing I started mysql using command prompt (mysqld-max)

3. i did comand mysql -uadmin

C:\mysql\bin>mysql -uadmin
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 3.23.58-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

4. When I do the following I get

mysql> status
mysql Ver 11.18 Distrib 3.23.58, for Win95/Win98 (i32)

Connection id: 14
Current database:
Current user: admin@localhost
Server version: 3.23.58-max
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
Uptime: 20 hours 48 min 7 sec

Threads: 1 Questions: 27 Slow queries: 0 Opens: 6 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.000


5. then when i do following i get error

mysql> create database testdb;
ERROR 1044: Access denied for user: '@localhost' to database 'testdb'
mysql> status

I exactly followed the steps of the book, can some tell me what i did wrong..I have not created any user yet. according to the book "At this point I am the root user who has access to everything", then i do not know why i can not create database...


Reply With Quote