1.把安装包mysql-5.1.60.tar.gz下载到/usr/local目录下减压
2.安装客户端与服务器
apt-get install mysql-server
apt-get install mysql-client
==============安全卸载mysql
停止mysql服务,如果不管用,就grep包括"mysql“的进程,全部pkill掉;
1:apt-get remove mysql-server --purge
2:apt-get remove mysql-common --purge
2:apt-get remove mysql-client --purge
加--purge实现完全卸载。
=========================================
a、数据库目录
/var/lib/mysql/
b、配置文件
/usr/share/mysql(mysql.server命令及配置文件)
c、相关命令
/usr/bin(mysqladmin mysqldump等命令)
d、启动脚本
=========================启动或者停止数据库
cd /usr/local目录下
service mysql start
service mysql stop /mysqladmin -u root -p shutdown
================================================
把"/var/lib/mysql"数据库文件整个目录移到"/mysql_data"(我没用这么做)
root@debian:/var/lib/mysql# mv /var/lib/mysql/ /opt/wksp/mysql_data/
进入msyql命令行
root@debian:/etc# mysql -u root -p
删除空用户,强烈建议。
mysql> delete from mysql.user where user='';
Query OK, 0 rows affected (0.00 sec)
刷新权限表,以便可以使更改立即生效。
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
创建数据库及查看
mysql> create database mystudentDB;
Query OK, 1 row affected (0.00 sec)
mysql> use mystudentDB;
Database changed
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| mystudentDB |
+--------------------+
3 rows in set (0.01 sec)
mysql> source /opt/wksp/CreatInsertStudent.sql
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM student;
+--------+--------+------+------+
| id | name | sex | age |
+--------+--------+------+------+
| 201201 | 张三 | 男 | 21 |
| 201202 | 李四 | 男 | 22 |
| 201203 | 王五 | 女 | 20 |
| 201204 | 赵六 | 男 | 21 |
| 201205 | 小红 | 女 | 19 |
| 201206 | 小明 | 男 | 22 |
+--------+--------+------+------+
6 rows in set (0.00 sec)
mysql> show tables;
+-----------------------+
| Tables_in_mystudentDB |
+-----------------------+
| student |
+-----------------------+
1 row in set (0.00 sec)
mysql> drop database mystudentDB;
Query OK, 1 row affected (0.00 sec)
如果查询出来的数据是乱码的话:
找到"my.ini"配置文件,最终发现my.ini里的2个character_set把client改成gbk,把server改成utf8就可以了。
debian下安装mysql
最新推荐文章于 2024-07-01 10:30:00 发布