mysql使用问题解决

mysql学习网站http://www.yiibai.com/mysql/mysql_quick_start.html

1. 服务端无法启动

刚在win10上装上Mysql，在cmd中更换目录到Mysql服务器所在目录，我的是C:\Program Files\MySQL\MySQL Server 5.6\bin， 输入mysqld.exe，无法启动mysql服务器，显示信息如下：

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld.exe
2015-08-05 00:06:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2015-08-05 00:06:17 0 [Note] mysqld.exe (mysqld 5.6.26) starting as process 14832 …
2015-08-05 00:06:17 14832 [Warning] Can’t create test file C:\Program Files\MySQL\MySQL Server 5.6\data\Yu.lower-test
2015-08-05 00:06:17 14832 [Warning] Can’t create test file C:\Program Files\MySQL\MySQL Server 5.6\data\Yu.lower-test
C:\Program Files\MySQL\MySQL Server 5.6\bin>

查了下网上资料说linux系统要chmod一下权限，想到win10 C盘的执行文件也有权限，右键点击mysqld.exe，用管理员身份运行即可，任务管理器中也有了mysqld进程，然后在cmd中输入mysql，即进入mysql，显示如下：

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
mysql>

PS:win10 cmd命令执行管理员权限的方式，在开始里所有应用，window系统，找到命令提示符，右键用管理员权限运行，就可以了，在此命令行中输入的命令都是管理员权限执行的。