|
1
| [iyunv@ultraera ~]# yum install mysql mysql-server mysql-devel
|
2.启动mysql,并设置开机自启动
1
2
3
4
| [iyunv@ultraera ~]# service mysqld start/stop/restart/status #启动/关闭/重启/状态
chkconfig mysqld on/off
[iyunv@ultraera ~]# chkconfig --list | grep mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off
|
3.相关配置
1
2
3
| /etc/my.cnf mysql配置文件
/var/lib/mysql mysql数据库文件
port:3306 mysql默认端口
|
5.注意事项
1
2
3
4
5
6
| mysql> quit #quit,退出,等同于ctrl+c
Bye
[iyunv@ultraera ~]#
; #MySQL 绝大对数语句都是以分号结尾,注意是英文模式下的分号。
字符和字符串用 ' ' 引起;
|
4.mysql初始化及登录
1
2
| [iyunv@ultraera ~]# mysql -u root -p '123456'
[iyunv@ultraera ~]# mysql -u root -p -h localhost “-h” 指定服务器地址
|
5.创建、查看及删除当前数据库
1
2
3
4
5
6
7
8
9
10
11
12
13
14
| mysql> CREATE DATABASE ultraera;
Query OK, 1 row affected (0.00 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| ultraera |
+--------------------+
4 rows in set (0.00 sec)
mysql> DROP DATABASE ultraera;
Query OK, 0 rows affected (0.00 sec)
|
6.创建、查看及删除当前表格
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| #创建表格之前要先选择数据库
mysql> use ultraera;
Database changed
mysql> CREATE TABLE ultraera( #create 创建表格,至少1列
-> id int NOT NULL, #NOT NULL 不为空,int 整型
-> name char(20) NOT NULL, #char() 字符型 ,()内定义字符长度
-> age int NOT NULL,
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> DESC ultraera;
+-------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+----------------+
| id | int(11) | NO | | NULL | |
| name | char(20) | NO | | NULL | |
| age | int(11) | NO | | NULL | |
+-------+----------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> DROP TABLE ultraera ;
Query OK, 0 rows affected (0.00 sec)
|
|
|