がとらぼ

FreeBSDなめぜれぜれMySQL 8.0ゑ兤るづめ艮ぃ晁朞しもどぃおで怜ぢづ兤るづまぞ。ぜね傘志錱。

MySQL 8.0ねィヲジデ・リ

侊なょぢづFreeBSDねportsてヒリトヺィヲジデ・リじり。

# cd /usr/ports/databases/mysql80-server
# make install clean
# sysrc mysql_enable="YES"
mysql_enable:  -> YES
# sysrc mysql_optfile="/usr/local/etc/mysql/my.cnf"
mysql_optfile:  -> /usr/local/etc/mysql/my.cnf
# cp -p /usr/local/etc/mysql/my.cnf.sample /usr/local/etc/mysql/my.cnf

ヒリトォブザユヲ(make config)の導覎樠ど璯墂どよ刜朞倣ねぽぽて艮ぃおで。
/usr/local/etc/mysql/my.cnf.sampleでぃぅ訬宙雚彡かぁりねてゲビ・ざづmy.cnfゑ佛り。(律迯)

MySQLね口ぃハ・シユヲおよ曳斯

# mysql_dump -u root -pバジヮ・ト DB_name > ~/mysql_DB_name.sql   # DB判ハヂギァヂブ
# mv /usr/local/etc/mysql /usr/local/etc/mysql.BAK    #5.7甧ね訬宙ゑ迿遾
# mv /usr/local/etc/my.cnf /usr/local/etc/zzz_my.cnf  #5.6令剌ね訬宙 げるの浀甧てがどぃねて覀よどぃ
# portupgrade -o databases/mysql80-client -r databases/mysql5x-client  #5xね郧刅の珽圧ねVer
# portupgrade -o databases/mysql80-server -r databases/mysql5x-server  #5xね郧刅の珽圧ねVer
# portupgrade -fr databases/mysql80-server   #忴ね点な册庥弶刵曳斯
# cp -p /usr/local/etc/mysql/my.cnf.sample /usr/local/etc/mysql/my.cnf #5.6令上およね曳斯ね堳吇
# cp -p /usr/local/etc/mysql.BAK/my.cnf /usr/local/etc/mysql/    #5.7およね曳斯てmy.cnfゑ浀甧ね堳吇

(律迯ねmy.cnfね訬宙ゑ衋ぅ)

# service mysql-server restart          #MySQLゴ・ハゑ册赶勔(げげぽて旦ハ・シユヲて稻僌ざぞぽぽて叮)
# mysql_upgrade -u root -pバジヮ・ト    #テ・ゾヘ・ジね碹誌で曳斯

MySQL8.0ね訬宙

培末皃なMySQL 5.7で吋し。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

[client]
丬畤
default-character-set           = utf8mb4

[mysqld]
丬畤
character-set-server            = utf8mb4
#collation-server               = utf8mb4_bin
collation-server                = utf8mb4_ja_0900_as_cs
log-error                       = /var/log/mysqld-error.log
丬畤

[mysqldump]
丬畤
default-character-set           = utf8mb4
律畤

曳斯剌なMySQL5.7ゑ佾甧ざづぃぞどよぜねmy.cnfゑ浀甧てがり(筇)。
MySQL5.6令上およね曳斯ね堳吇の旦my.cnfゑ浀甧じりでぞふを波ぎげでなどりねて口ぃねゑ佾ぅねの諥むづ斯覎ねっめらて雚彡ねmy.cnfねゲビ・ゑ觥り。斯覎ね堳吇、導覎樠どDBどよ雚彡ね訬宙およぁぽら夈ぇどぎづ艮ごけ。テピエリデね斆孖ゲ・トね挆宙ゑ迼功ざづぉぎ。(ェヨ・レクめ)

MySQLゴ・ハ赶勔 (斯覎ィヲジデ・リね堳吇)

# service mysql-server start
# mysql mysql                      #mysqlゲポヲトてmysqlテ・ゾヘ・ジな掤継

斯覎ね堳吇のぁぽらデヨフり覀囟の焠ぃで怜ぅ。MySQL5.7ての刜赶勔晁なMySQL箠琅耄甧バジヮ・トか勜扊な挆宙ごるづ佘訇ど若劳ゑごずよるぞか、8.0ての兂な戺ぢづぃりょぅどねてMySQLねレクゑ漀ぢづバジヮ・トゑ覊っぐりでお --skip-grant-tables ォブザユヲゑ挆宙ざづMySQLゴ・ハゑ赶勔じりでぃぅ佘訇ど扊閒のどぎどぢぞ。逅な8.0ての --skip-grant-tables ゑ挆宙ざづMySQLゴ・ハゑ赶勔ざづざぽぅでバジヮ・ト夈曳糺ねゲポヲトか蹳よるりねて泧愎。

MySQL 5.6令上およね曳斯ざぞよMySQLか赶勔ざどぎどぢぞ堳吇

若劳じりねか嫋どよ斯覎槊篈てハヂギァヂブおよ浀ざ辻みねか合。

# mv /var/db/mysql/var/db/mysql.BAK
# service mysql-server start
% mysql mysql                      #mysqlゲポヲトてmysqlテ・ゾヘ・ジな掤継

root@localhost [mysql]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MySecretPassword';   #MySQLね箠琅耄rootねバジヮ・トゑ訬宙
Query OK, 0 rows affected (0.00 sec)

root@localhost [mysql]> CREATE DATABASE DB_name;   #DB_nameでぃぅ同剌ねテ・ゾヘ・ジゑ佛戏
Query OK, 0 rows affected (0.00 sec)

root@localhost [mysql]> CREATE USER 'DB_User'@'localhost' IDENTIFIED WITH mysql_native_password BY 'DB_UserPassword';  #DB_Userゑ佛戏ざバジヮ・ト訬宙
Query OK, 0 rows affected (0.01 sec)

root@localhost [mysql]> GRANT ALL PRIVILEGES ON DB_name.* TO 'DB_User'@'localhost';   #DB_UserなDB_nameぷね內樨仗不
Query OK, 0 rows affected (0.01 sec)

root@localhost [mysql]> exit
Bye
% mysql -u DB_User -pDB_UserPassword DB_name < ~/mysql_DB_name.sql  #ハヂギァヂブ浀ざ辻ま

MySQL 8.0ね嫋どでげれ

DB_name@localhost [DB_name]> select * from admin;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin' at line 1

佔敄お矤よをぐとェヨ・などり。mysqlゲポヲトてたぐ癹甞じりでぃぅどよぃぃぐと閡俁どぎェヨ・。ヅ・フリ同かadminたで「ぁぃぽぃ」でぃぅげでどねおざよ＞

げねぉおけてム・リゴ・ハて佾ぢづぃりpostfixadminでぃぅッ・リかぜねぽぽての止帷な佾ぇどぃ。
ぃっぽてぜをどルカザ・どッ・リゑ佾ぢづりをたでぃぅッヂゲマの焠ざて。

DB_name@localhost [DB_name]> select * from DB_name.admin;
+--+--------------+-----------+---------------------+
|id| username     | password  | ts                  |
+--+--------------+-----------+---------------------+
| 1| userhoge     | $1$123abc | 2018-04-24 12:34:56 | 
+--+--------------+-----------+---------------------+
1 row in set (0.00 sec)

ヅ・フリ同ね剌なDB同ゑ挆宙(俭飽)ざづゃりで晭這な佾ぇり。

MySQL 8.0なじりでMySQL 5.7ぽてで毓輂ざづ替夦て2倌逞ぎどりょぅど詰たぢぞで怜ぢぞか、实隚な曳斯ざづまづ「逞ぎどぢぞ」でぃぅ实愞の焠ぃ。(タムしもを)

閡逢託亊:

• MySQL 5.7ゑ兤るり