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.
可是我找 ......
在三十讲遇到这样一个问题就是运行代码时出现错误 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 ......
我对SQL SERVER和ACCESS比较熟,所以数据库的通用基础东西可以说都掌握的差不多了,我现在想要的就是以上两数据库的独特之处的介绍和应用介绍。
另外书最好对应最新版本 oracle是11g吧 10的也行;mysql是5.1吧
谢 ......
我开发ASP.net时
插入外文乱码
SHOW VARIABLES LIKE 'character%';
这个时候
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
请问下哪位仁兄有比较好的备份方案,用什么工具或者用什么方式,小弟借鉴下
直接用MYSQLDUMP备份
OR
用SQLYOG之类的图形化管理工具备份
直接用mysql自带的 mysqldump 就可以了。
http://dev.mysql.com/doc/re ......