MySQL 问题,急求
这是什么问题? 192.168.4.204就是本机
SQL code:
C:\Program Files\McAfee\Network Security Manager\MySQL\bin>mysql -h192.168.4.204 -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28799
Server version: 5.0.68-enterprise-nt-log MySQL Enterprise Server (Commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select version();
+--------------------------+
| version() |
+--------------------------+
| 5.0.68-enterprise-nt-log |
+--------------------------+
1 row in set (0.00 sec)
mysql> use mysql
Database changed
mysql> select host,user from user;
+---------------+------+
| host | user |
+---------------+------+
| 192.168.4.204 | root |
+---------------+------+
1 row in set (0.00 sec)
mysql> grant all privileges on *.* to root@'%' indentified by 'qwerty';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'indentified by 'qwerty'' at line 1
mysql>
grant all on *.* to root@'%' indentified by 'qwerty';
楼上的都不可以
SQL code:
mysql&g
相关问答:
我以前安装了一次,后来卸载了,现在再安装的时候,提示错误:Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
可是我找 ......
有个winform程序,使用c#+mysql,需要在一个窗体设置mysql自动删除功能,包括自动删除多少天之前的数据以及是否开启自动删除功能,我程序退出后,还怎么控制Mysql自己删除啊?是不是要用mysql的event来实现?c#可以调用mysq ......
在三十讲遇到这样一个问题就是运行代码时出现错误 Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12
,我把mysql::fetch_array() 改成mysql::fetch_row() 又出现F ......
我开发ASP.net时
插入外文乱码
SHOW VARIABLES LIKE 'character%';
这个时候
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......