Java开发网 - MySQL数据库的创建（急）

Topic: MySQL数据库的创建（急）

1.MySQL数据库的创建（急）

Posted by: beter1
Posted on: 2004-08-28 01:26

我的系统是windownsXP 我用的MySQL是mysql-5.0.0a-alpha-win ODBC驱动是MyODBC-standard-3.51.9-win.exe 出现的问题是这样的：
C:\>mysql
Welcome to the...
...
..... to clear the buffer.
mysql>create database mysqldemo;
ERROR 1044 (42000):Access denied for ueser.''@'loalhost' todatabase
'mysqldemo'
mysql>
--------------------------------------------------------------------------------------------------
ERROR 1044 (42000):Access denied for ueser.''@'loalhost' todatabase
'mysqldemo'
我是照书上一步一步的搞的，可是为什么是这样的呢？我找了好多书也不知道怎么解决，那位大哥帮帮忙，告诉我怎么搞。

2.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: nothing Posted on: 2004-08-28 02:57 mysql -u root

3.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: beter1 Posted on: 2004-08-28 13:02 这样的 mysql>mysql -u root ->create databae mydb; ERROR 1064 (42000):You have an error in your SQLsyntax.Check the manual that corresponds to your MySQL serner version for the right syntaxtouse near 'mysql -u root create database mydb' at line 1 mysql> 还是不行啊老大。

4.Re:MySQL数据库的创建（急） [Re: beter1]

Copy to clipboard

Posted by: nothing
Posted on: 2004-08-28 13:14



d:\>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.20a-nt

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

mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.01 sec)

mysql> create database mydb1;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+----------+
| Database |
+----------+
| mydb1    |
| mysql    |
| test     |
+----------+
3 rows in set (0.01 sec)

mysql>

5.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: beter1 Posted on: 2004-08-28 18:59 谢谢老大，我搞出来了，我真是双腿一软啦~~！！我一个人摸索着学java，没有一个人指导一下，哎。。。。一言难尽啊！谢谢了！！

6.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: goodtime_wbg Posted on: 2004-10-26 20:29 我也是受益的很，自己摸索着学太花力气了，谢谢老大！

7.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: songbenlijia Posted on: 2004-11-15 17:54 我也搞出来了，但我还是不明白开始为什么不对（我也出现的相同的问题）

8.Re:MySQL数据库的创建（急） [Re: beter1]	Copy to clipboard
Posted by: sanshaoye Posted on: 2004-11-16 11:00 The first, users have no permit to create database,so you must login as root. The second, "->create databae mydb;" have SQL syntax error, 'databae' could be 'database'.