请教MySQL问题

suncrow

bash-3.00$ /usr/local/mysql/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.23.58-log

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

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


请问为何无法建立？？谢谢~~~~~~~~~~~~~~~

suejane

是不是用户没用创建权限，你是用root登录的吗？

NETFOX

如果是本地登录，你又没有修改过配置文件！

那么请用  mysql -u root -p
password:

password 在mysql刚刚安装默认是没有的，

mysqladmin -u root password "yourpasswd"

登录mysql以后，GRANT ALL ON *.* TO root@% IDENTFIED BY "yourpasswd"