ubuntu 14.04 安裝mysql

While?MySql?5.5?is?the?default?for?Ubuntu?14.04,?MySql?5.6?is?available?in?the?default?repositories.?It?can?be?installed?simply?using:

sudo?apt-get?update
sudo?apt-get?upgrade
sudo?apt-get?install?mysql-server-5.6

If you have existing data in a MySql 5.5 database, it should be migrated automatically. Though it is always a good idea to make a backup before doing a major upgrade.

First make a backup of the data in your existing database:

mysqldump?--lock-all-tables?-u?root?-p?--all-databases?>?dump.sql

mysqldump?-u?USERNAME?-p?--default-character-set=utf8mb4?USER_DATABASE?>?backup.sql

Then after installing the newer version, you can restore if needed by running:

mysql?-u?root?-p?<?dump.sql

mysql?-u?root?-p?數(shù)據(jù)庫名?<?dump.sql

mysql?-u?USERNAME?-p??--default-character-set=utf8mb4?USER_DATABASE?<?backup.sql

mysql修改遠(yuǎn)程連接

第一步：

vim /etc/mysql/my.cnf找到bind-address = 127.0.0.1

注釋掉這行，如：#bind-address = 127.0.0.1

或者改為：?bind-address = 0.0.0.0

允許任意IP訪問；

或者自己指定一個(gè)IP地址。

重啟 MySQL：sudo /etc/init.d/mysql restart

第二步：

授權(quán)用戶能進(jìn)行遠(yuǎn)程連接

???grant all privileges on *.* to root@"%" identified by "password" with grant option;

???flush privileges;

?? 第一行命令解釋如下，*.*：第一個(gè)*代表數(shù)據(jù)庫名；第二個(gè)*代表表名。這里的意思是所有數(shù)據(jù)庫里的所有表都授權(quán)給用戶。root：授予root賬號(hào)。“%”：表示授權(quán)的用戶IP可以指定，這里代表任意的IP地址都能訪問MySQL數(shù)據(jù)庫。“password”：分配賬號(hào)對(duì)應(yīng)的密碼，這里密碼自己替換成你的mysql root帳號(hào)密碼。

?? 第二行命令是刷新權(quán)限信息，也即是讓我們所作的設(shè)置馬上生效。

為了消除linux環(huán)境下大小寫敏感問題，設(shè)置如下：vi /etc/mysql/my.cnf

在[mysqld]中添加：

lower_case_table_names = 1;

utf8mb4配置

[mysqld] character-set-server = utf8mb4 [mysql] default-character-set = utf8mb4