本人博客供參考
在巢湖等地區(qū),都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局,加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力,以專注、極致的服務(wù)理念,為客戶提供成都網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì) 網(wǎng)站設(shè)計(jì)制作按需策劃設(shè)計(jì),公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站設(shè)計(jì),網(wǎng)絡(luò)營(yíng)銷推廣,外貿(mào)網(wǎng)站建設(shè),巢湖網(wǎng)站建設(shè)費(fèi)用合理。
網(wǎng)頁(yè)鏈接
下載mysql源安裝包shell wget??
安裝mysql源shell yum localinstall mysql57-community-release-el7-8.noarch.rpm?
檢查mysql源是否安裝成功?
yum repolist enabled | grep “mysql.-community.”?
安裝MySQL?
yum install mysql-community-server?
啟動(dòng)MySQL服務(wù)?
shell systemctl start mysqld?
查看MySQL的啟動(dòng)狀態(tài)?
shell systemctl status mysqld?
開機(jī)啟動(dòng)?
shell systemctl enable mysqld?
shell systemctl daemon-reload?
修改root本地登錄密碼?
mysql安裝完成之后,在/var/log/mysqld.log文件中給root生成了一個(gè)默認(rèn)密碼。通過(guò)下面的方式找到root默認(rèn)密碼,然后登錄mysql進(jìn)行修改:?
shell grep ‘temporary password’ /var/log/mysqld.log?
shell mysql -uroot -p?
mysql ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘MyNewPass4!’;?
或者:?
mysql set password for ‘root’@’localhost’=password(‘MyNewPass4!’);?
注意:mysql5.7默認(rèn)安裝了密碼安全檢查插件(validate_password),默認(rèn)密碼檢查策略要求密碼必須包含:大小寫字母、數(shù)字和特殊符號(hào),并且長(zhǎng)度不能少于8位。否則會(huì)提示ERROR 1819 (HY000): Your password does not satisfy the current policy requirements錯(cuò)誤?
添加遠(yuǎn)程登錄用戶?
默認(rèn)只允許root帳戶在本地登錄,如果要在其它機(jī)器上連接mysql,必須修改root允許遠(yuǎn)程連接,或者添加一個(gè)允許遠(yuǎn)程連接的帳戶,為了安全起見,我添加一個(gè)新的帳戶:?
mysql GRANT ALL PRIVILEGES ON?.?TO ‘yangxin’@’%’ IDENTIFIED BY ‘Yangxin0917!’ WITH GRANT OPTION;
以上部分個(gè)人實(shí)踐過(guò),以下內(nèi)容待實(shí)踐
數(shù)據(jù)庫(kù)存emoji 表情問(wèn)題
mysql SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;?
+————————–+——————-+?
| Variable_name | Value |?
+————————–+——————-+?
| character_set_client | utf8 |?
| character_set_connection | utf8 |?
| character_set_database | latin1 |?
| character_set_filesystem | binary |?
| character_set_results | utf8 |?
| character_set_server | latin1 |?
| character_set_system | utf8 |?
| collation_connection | utf8_general_ci |?
| collation_database | latin1_swedish_ci |?
| collation_server | latin1_swedish_ci |?
+————————–+——————-+?
10 rows in set (0.02 sec)?
可以看到我的mysql版本是5.7的,utf8mb4有一個(gè)使用限制,mysql版本必須是5.5以上,大家需要注意,我目前用的ubuntu系統(tǒng)是16.04的。當(dāng)前mysql的字符集配置如上表,我們的目的是更改成utf8mb4。?
3.找到mysql的配置文件,可用命令?
sudo find / -name my.cnf?
我的配置文件位置如下,個(gè)別的位置有所不同?
/etc/mysql/mysql.conf.d/mysqld.cnf
4.修改配置文件?
在原文中添加以下內(nèi)容:?
[client]?
default-character-set = utf8mb4?
[mysql]?
default-character-set = utf8mb4?
[mysqld]?
character-set-client-handshake = FALSE?
character-set-server = utf8mb4?
collation-server = utf8mb4_unicode_ci?
init_connect=’SET NAMES utf8mb4’?
原文件中無(wú)“[client]”和“[mysql]”,需要手動(dòng)添加上。?
……
Here is entries for some specific programs
The following values assume you have at least 32M ram
[client]?
default-character-set = utf8mb4?
[mysql]?
default-character-set = utf8mb4?
[mysqld_safe]?
socket = /var/run/mysqld/mysqld.sock?
nice = 0?
[mysqld]?
#
* 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?
skip-external-locking?
character-set-client-handshake = FALSE?
character-set-server = utf8mb4?
collation-server = utf8mb4_unicode_ci?
init_connect=’SET NAMES utf8mb4’?
#
Instead of skip-networking the default is now to listen only on
……
5.重啟mysql服務(wù)?
sudo service mysql restart
6.查看結(jié)果?
mysql SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;?
ERROR 2006 (HY000): MySQL server has gone away?
No connection. Trying to reconnect…?
Connection id: 3?
Current database:?* NONE *?
+————————–+——————–+?
| Variable_name | Value |?
+————————–+——————–+?
| character_set_client | utf8mb4 |?
| character_set_connection | utf8mb4 |?
| character_set_database | utf8mb4 |?
| character_set_filesystem | binary |?
| character_set_results | utf8mb4 |?
| character_set_server | utf8mb4 |?
| character_set_system | utf8 |?
| collation_connection | utf8mb4_unicode_ci |?
| collation_database | utf8mb4_unicode_ci |?
| collation_server | utf8mb4_unicode_ci |?
+————————–+——————–+?
10 rows in set (0.00 sec)
1、查找以前是否裝有mysql命令:rpm -qa|grep -i mysql
可以看到如下圖的所示:
說(shuō)明之前安裝了:
MySQL-client-5.5.25a-1.rhel5
MySQL-server-5.5.25a-1.rhel5
2、停止mysql服務(wù)、刪除之前安裝的mysql
刪除命令:rpm -e –nodeps 包名
# rpm -ev MySQL-client-5.5.25a-1.rhel5
# rpm -ev MySQL-server-5.5.25a-1.rhel5
3、查找之前老版本mysql的目錄、并且刪除老版本mysql的文件和庫(kù)
find / -name mysql
查找結(jié)果如下:
[root@localhost ~]# find / -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql
刪除對(duì)應(yīng)的mysql目錄
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
具體的步驟如圖:查找目錄并刪除
注意:卸載后/etc/my.cnf不會(huì)刪除,需要進(jìn)行手工刪除
rm -rf /etc/my.cnf
4、再次查找機(jī)器是否安裝mysql
rpm -qa|grep -i mysql
無(wú)結(jié)果,說(shuō)明已經(jīng)卸載徹底、接下來(lái)直接安裝mysql即可
1.備份舊版mysql中的所有數(shù)據(jù)庫(kù) 在cmd中進(jìn)入舊版mysql安裝目錄下的bin目錄。 我的目錄(默認(rèn)安裝位置)是: C:\Program Files\MySQL\MySQL Server 5.5\bin ...
2.完全卸載舊版mysql 停止mysql服務(wù) win+R→輸入services.msc→服務(wù)→找到mysql并停止。 卸載mysql程序,mysql免安裝版的刪除安裝目錄即可 win+R→輸入control→...
分享題目:關(guān)于macos+系統(tǒng)如何更新的信息
轉(zhuǎn)載來(lái)于:http://muchs.cn/article38/hsscsp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供定制網(wǎng)站、關(guān)鍵詞優(yōu)化、網(wǎng)站維護(hù)、、App開發(fā)、微信公眾號(hào)
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)