SQL(Structured Query Language)结构化查询语言
MySQL - 关系型数据库
在MySQL的bin目录下执行命令
命令行登录mysql:
- mysql -u root -p
安装MySQL
- Debian or Ubuntu:sudo apt-get install mysql mysql-server
- CentOS:sudo yum install mysql mysql-server
添加root用户密码
- mysqladmin -u root -p password ‘newpwd’
MySQL配置文件路径
- Windows:C:\Program File\MySQL\MySQL Server 5.6\my-default
- Linux:/etc/my.cnf
- Mac:/usr/local/mysql/my.cnf
修改配置文件
- [client]
default-character-set=utf8 - [mysqld]
character-set-server=utf8
default-storage-engine=INNODB
重启MySQL
- Windows:通过Windows服务重启
- Linux:/etc/init.d/mysqld restart
- Mac:sudo /Library/Startupltems/MySQLCOM/MYSQLCOM restart