用这个root登录增删改查可以,
但创建数据库无权限,修改表结构也不行创建一个新的数据库:
无权限错误
SQL 查询: ALTER TABLE `carioinfo` CHANGE `tijiaoren` `tijiaoren` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL MySQL 返回: #1142 - ALTER command denied to user 'root'@'127.0.0.1' for table 'carioinfo' 请教该如何是好?
但创建数据库无权限,修改表结构也不行创建一个新的数据库:
无权限错误
SQL 查询: ALTER TABLE `carioinfo` CHANGE `tijiaoren` `tijiaoren` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL MySQL 返回: #1142 - ALTER command denied to user 'root'@'127.0.0.1' for table 'carioinfo' 请教该如何是好?
grant all privileges on *.* to root@'%' identified by "Passwd"
-- 设置mysql root账号密码以及root账号初始化
-- ===============================================================
shell>/usr/local/mysql/bin/mysqladmin –u root password ‘password’重新设置root账号
http://topic.csdn.net/u/20090515/21/2b3c9a12-d8a5-4bb1-9895-6069cef5aef8.html
按照这个方法,进去后再给ROOT授权一下即可。
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
mysql>
怎么办啊
D:\APMServ\MySQL5.1\bin>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.1.28-rc-community MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> grant all privileges on *.* to root@'%' identified by "Passwd" ;
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
mysql>
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables opt
ion so it cannot execute this statement
具体怎么insert能否赐教?