首先推荐一款mac软件包管理用具brew,具体安装方法这里就不介绍了,百度一堆方法,brew类似Python的conda包管理工具。
话不多说,打开mac的terminal,输入如下命令:
brew install mysql
根据网速的不同,下载完成所需要的时间也不同,如果出现下面文字,证明你安装成功了。
启动mysql:
mysql.server start
接下来,对mysql进行简单设置:
mysql_secure_installation
设置密码强度,直到提示密码强度为100,方可进行后面的设置:
接下来就是设置,是否允许远程root权限,是否保留test数据库等:
以root权限进入数据库:
mysql -u root -p
最后,我们就可以对mysql进行任何操作了,success!!!
// 创建数据库firstDB:
mysql> create database firstDB;
Query OK, 1 row affected (0.01 sec)mysql> create database firstDB;
Query OK, 1 row affected (0.01 sec)
// 查看所有数据库:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| firstDB |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
// 进入firstDB数据库:
mysql> use firstDB;
Database changedmysql> use firstDB;
Database changed
// 创建表格user
mysql> create table user(id int primary key auto_increment,
-> username varchar(32) unique not null,
-> password varchar(32) not null);
Query OK, 0 rows affected (0.02 sec)
// 查看firstDB中的所有表格:
mysql> show tables;
+-------------------+
| Tables_in_firstdb |
+-------------------+
| user |
+-------------------+
1 row in set (0.00 sec)
// 查看表格属性信息:
mysql> desc user
-> ;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(32) | NO | UNI | NULL | |
| password | varchar(32) | NO | | NULL | |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
// 表格中插入数据:
mysql> insert into user values(1,'Jesse','jesse');
Query OK, 1 row affected (0.00 sec)
// 查看表格中的数据:
mysql> select * frome user;
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 'frome user' at line 1
mysql> select * from user;
+----+----------+----------+
| id | username | password |
+----+----------+----------+
| 1 | Jesse | jesse |
+----+----------+----------+
1 row in set (0.00 sec)
mysql>
本文分享自 MiningAlgorithms 微信公众号,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文参与 腾讯云自媒体同步曝光计划 ,欢迎热爱写作的你一起参与!