ubuntu mysql安装

一.安装

sudo apt-get install mysql-sever

 

二.登录

mysql -u root -p

 

三.编码

1.show variables like 'character%'

2.vi /etc/mysql/mysql.conf.d/mysqld.cnf

添加在lc-messages-dir = /usr/share/mysql后面

character-set-server=utf8

3.vi /etc/mysql/conf.d/mysql.cnf

default-character-set=utf8

 

4.vi /etc/mysql/my.cnf

[client]

default-character-set=utf8
[mysql]

character-set-server-=utf8

5./etc/init.d/mysql restart/start/stop

 

6.create user

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

CREATE USER 'root'@'%' IDENTIFIED BY 'root';

grant all privileges on db_name.table_name to 'username'@'%';

grant all privileges on *.* to 'root'@'%';

flush privileges;

7.更改mysql存储路径

关闭mysql服务 /etc/init.d/mysql stop

复制原有数据 cp -r /var/lib/mysql/* /mnt/mysql/

修改权限 chown -R mysql:mysql /mnt/mysql/

修改存储路径 vi /etc/mysql/mysql.conf.d/mysqld.cnf

datadir=/mnt/mysql

vi /etc/apparmor.d/usr.sbin.mysqld

/var/lib/msyql/ r,

/var/lib/mysql/** rwk,

修改为

/mnt/mysql r,

/mnt/mysql/** rwk,

重启

/etc/init.d/apparmor restart

/etc/init.d/mysql restart

 

8.navicat导出数据库结构

选择数据库-》点击右键-》数据传输-》文件-》高级去掉基类-》操作

 

 

其他

show databases;

use tablename

show tables;

show create table tablename

desribe tablename

alter table name default character set utf8

source /etc/sphinxsearch/example.sql

CREATE DATABASE name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;