linux下 Mysql 安装使用

1、安装mysql
sudo apt-get install mysql-server mysql-client
sudo service mysql restart

2、5.7版本以上修修改
update mysql.user set authentication_string=PASSWORD('command'), plugin='mysql_native_password' where user='root';


2、配置可远程
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'command' WITH GRANT OPTION
mysql>flush privileges;

0：区分大小写，1：不区分大小写
lower_case_table_names=1
lower_case_table_names=0

vi   /etc/my.cnf  设置如下内容(清空原先内容)
[client]
default-character-set=utf8
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
character-set-server = utf8
#character-set-server=utf8
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
lower_case_table_names=1
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 0.0.0.0
#

启动
/etc/init.d/mysql start
停止
/etc/init.d/mysql stop

登录
mysql -uroot -pbreak //登录本地
mysql -h127.0.0.1 -uroot -pbreak  -P端口

导入数据（注意sql文件的路径）
mysql>source /home/viewfocus.sql;
导出数据
mysqldump -u root -p viewfocus > viewfocus.sql

mysql升级5.7

wget https://dev.mysql.com/get/mysql-apt-config_0.8.1-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.1-1_all.deb
sudo apt-get install mysql-server

导出存储过程

mysqldump -R -ndt dbname -u root -p > xxx.sql