以下信息基于MySQL 5.7
- MySQL Installation Layout on macOS
Directory | Contents of Directory |
---|---|
bin | mysqld server, client and utility programs |
data | Log files, databases |
docs | Helper documents, like the Release Notes and build information |
include | Include (header) files |
lib | Libraries |
man | Unix manual pages |
mysql-test | MySQL test suite |
share | Miscellaneous support files, including error messages, sample configuration files, SQL for database installation |
support-files | Scripts and sample configuration files |
/tmp/mysql.sock | Location of the MySQL Unix socket |
- 更改或设置root密码
- 当使用MySQL原版的安装程序时,root账户在安装程序结束后,会产生一个初始默认密码,应当及时更改这个初始密码。当root账户的初始默认密码过期后,首先使用该密码连接到MySQL服务器,然后再设置新密码,如果不知道初始密码,请参考错误信息日志(\usr\local\mysql\data\mysqld.local.err)
然后设置新密码shell> mysql -u root -p Enter password: (enter the random root password here)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
- 如果root没有初始密码:
然后设置密码$ mysql -u root --skip-password
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
- 常用命令语句
- 启动停止MySQL服务
- 启动服务:
$ sudo bin/mysqld_safe --user=mysql &
- 停止服务:
$ bin/mysqladmin -u root shutdown
- 检查MySQL版本信息
$ bin/mysqladmin -u root -p version
- 显示当前服务器上有哪些数据库以及数据库中有哪些表
$ mysqlshow -u root -p $ mysqlshow -u root -p scraping
- 连接MySQL服务器
$ mysql -h host -u user -p # 如果服务器在本机,则运行如下命令 $mysql -u user -p
- 从MySQL服务器退出
mysql> QUIT
- MySQL数据库服务器基本信息查询
mysql> SELECT VERSION(); mysql> SELECT NOW(); mysql> SELECT USER(); mysql> SHOW DATABASES;
- MySQL数据库服务器操作命令
mysql> SELECT DATABASE(); mysql> USE mydatabase; mysql> CREATE DATABASE menagerie; mysql> SHOW TABLES; mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); mysql> DESCRIBE pet; mysql> LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet; mysql> INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL);
- 启动停止MySQL服务