Isalathiso senqaku
indlela yokulawulaMySQL database? Ulawulo lomyalelo we-SSHMySQL服务器
MySQL Ulawulo
Qala kwaye umise iseva ye-MySQL
Okokuqala, kufuneka sijonge ukuba iseva ye-MySQL iphezulu ngokuqhuba lo myalelo ulandelayo:
ps -ef | grep mysqld
Ukuba i-MySql sele iqalisiwe, lo myalelo ungasentla uya kukhupha uluhlu lweenkqubo ze-mysql, ukuba i-mysql ayiqalwanga, ungasebenzisa lo myalelo ulandelayo ukuqalisa iseva ye-mysql:
root@host# cd /usr/bin ./mysqld_safe &
Ukuba ufuna ukuvala iseva ye-MySQL esebenzayo ngoku, ungenza lo myalelo ulandelayo:
root@host# cd /usr/bin ./mysqladmin -u root -p shutdown Enter password: ******
Iisetingi zoMsebenzisi weMySQL
Ukuba ufuna ukongeza umsebenzisi we-MySQL, udinga nje ukongeza umsebenzisi omtsha kwitafile yomsebenzisi kwi-database ye-mysql.
Oku kulandelayo ngumzekelo wokongezwa komsebenzisi, igama lomsebenzisi lundwendwe, igama eliyimfihlo lindwendwe123, kwaye umsebenzisi ugunyazisiwe ukwenza KHETHA, UKUFAKA NOHLAZIYA imisebenzi:
root@host# mysql -u root -p Enter password:******* mysql> use mysql; Database changed mysql> INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'guest', PASSWORD('guest123'), 'Y', 'Y', 'Y'); Query OK, 1 row affected (0.20 sec) mysql> FLUSH PRIVILEGES; Query OK, 1 row affected (0.01 sec) mysql> SELECT host, user, password FROM user WHERE user = 'guest'; +-----------+---------+------------------+ | host | user | password | +-----------+---------+------------------+ | localhost | guest | 6f8c114b58f2ce9e | +-----------+---------+------------------+ 1 row in set (0.00 sec)
Xa ufaka umsebenzisi, nceda uqaphele ukuba igama eligqithisiweyo lifihliwe kusetyenziswa PASSWORD () umsebenzi onikezwe nguMySQL.Ungabona kulo mzekelo ungasentla ukuba igama eliyimfihlo lomsebenzisi elifihliweyo lithi: 6f8c114b58f2ce9e.
Qaphela:Kwi-MySQL 5.7, igama eligqithisiweyo letafile yomsebenzisi lithathelwe indawo yiauthentication_string,
Qaphela:Qaphela imfuneko yokuphumeza FLUSH AMALUNGELO ingxelo.Emva kokuba lo myalelo uphunyeziwe, itafile yesibonelelo iya kulayishwa kwakhona.
Ukuba awusebenzisi lo myalelo, awuyi kukwazi ukusebenzisa umsebenzisi omtsha ukudibanisa kumncedisi we-mysql ngaphandle kokuba uqale kabusha iseva ye-mysql.
Xa usenza umsebenzisi, ungakhankanya iimvume zomsebenzisi.Kuluhlu lwemvume ehambelanayo, yibeke ku-'Y' kwisiteyitimenti sofakelo.Uluhlu lweemvume zomsebenzisi lungolu lulandelayo:
- Khetha_okuyimfihlo
- Insert_priv
- Hlaziya_priv
- Cima_imfihlo
- Create_priv
- drop_priv
- Layisha kwakhona_imfihlo
- shutdown_priv
- Inkqubo_yabucala
- Ifayile_priv
- Grant_priv
- IiReferensi_priv
- Index_priv
- Alter_priv
Enye indlela yokongeza abasebenzisi kungomyalelo we-GRANT we-SQL Umyalelo olandelayo uyakongeza umsebenzisi u-zara kwindawo echaziweyo ye-TUTORIALS yedatha, kwaye igama eliyimfihlo lithi zara123.
root@host# mysql -u root -p password; Enter password:******* mysql> use mysql; Database changed mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON TUTORIALS.* -> TO 'zara'@'localhost' -> IDENTIFIED BY 'zara123';
Umyalelo ongentla uza kudala irekhodi yolwazi lomsebenzisi kwitafile yomsebenzisi kwi-database ye-mysql.
Phawula: Iingxelo ze-MySQL ze-SQL zipheliswa nge-semicolon (;).
/etc/my.cnf uqwalaselo lwefayile
Phantsi kweemeko eziqhelekileyo, awudingi ukuguqula ifayile yoqwalaselo, uqwalaselo olungagqibekanga lwefayile ngolu hlobo lulandelayo:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Kwifayile yoqwalaselo, ungakhankanya uvimba weefayili apho iifayile zelogi ezahlukeneyo zempazamo zigcinwa khona.
Imiyalelo yokulawula iMySQL
Oku kulandelayo kudwelisa imiyalelo eqhele ukusetyenziswa kwinkqubo yokusebenzisa isiseko sedata seMysql:
- SEBENZISA Igama lokugcina idatha :
Khetha i-database ye-Mysql eza kusetyenziswa Emva kokusebenzisa lo myalelo, yonke imiyalelo ye-Mysql yeyesiseko sedatha kuphela.mysql> use chenweiliang; Database changed
- BONISA IIDABASE:
Udwelisa uluhlu lwesiseko sedatha yenkqubo yolawulo lwesiseko sedatha yeMySQL.mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | chenweiliang | | cdcol | | mysql | | onethink | | performance_schema | | phpmyadmin | | test | | wecenter | | wordpress | +--------------------+ 10 rows in set (0.02 sec)
- BONISA IITHEBILE:
Bonisa zonke iitheyibhile zedathabheyisi ekhankanyiweyo Ngaphambi kokusebenzisa lo myalelo, kufuneka usebenzise umyalelo wosetyenziso ukukhetha uvimba wedatha oza kusetyenziswa.mysql> use chenweiliang; Database changed mysql> SHOW TABLES; +------------------+ | Tables_in_chenweiliang | +------------------+ | employee_tbl | | chenweiliang_tbl | | tcount_tbl | +------------------+ 3 rows in set (0.00 sec)
- BONISA IKHOLAM ESUKA ishiti yedatha:
Bonisa iimpawu zetafile yedatha, iintlobo zeempawu, ulwazi oluphambili olungundoqo, nokuba luyi-NULL, ixabiso elingagqibekanga kunye nolunye ulwazi.mysql> SHOW COLUMNS FROM chenweiliang_tbl; +-----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | chenweiliang_id | int(11) | NO | PRI | NULL | | | chenweiliang_title | varchar(255) | YES | | NULL | | | chenweiliang_author | varchar(255) | YES | | NULL | | | submission_date | date | YES | | NULL | | +-----------------+--------------+------+-----+---------+-------+ 4 rows in set (0.01 sec)
- BONISA ISALATHISO SUKA ishiti yedatha:
Bonisa ulwazi lwesalathiso oluneenkcukacha lwetheyibhile yedatha, kubandakanywa ISINQONDO SOMNQOPHISO (iqhosha lokuqala).mysql> SHOW INDEX FROM chenweiliang_tbl; +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | chenweiliang_tbl | 0 | PRIMARY | 1 | chenweiliang_id | A | 2 | NULL | NULL | | BTREE | | | +------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 1 row in set (0.00 sec)
- BONISA IMEKO YETHEYIBHILE NJENGE [UKUSUKA db_igama] [NJENGA 'ipatheni'] \G:
Lo myalelo uya kukhupha ukusebenza kunye neenkcukacha zenkqubo yolawulo lwesiseko sesiseko seMysql.mysql> SHOW TABLE STATUS FROM chenweiliang; # 显示数据库 chenweiliang 中所有表的信息 mysql> SHOW TABLE STATUS from chenweiliang LIKE 'chenweiliang%'; # 表名以chenweiliang开头的表的信息 mysql> SHOW TABLE STATUS from chenweiliang LIKE 'chenweiliang%'\G; # 加上 \G,查询结果按列打印
Ndiyathemba Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwana "Uyilawula njani isiseko sedatha yeMySQL? Imiyalelo ye-SSH yokuLawula iiSeva zeMySQL", iya kukunceda.
Wamkelekile ukwabelana ngekhonkco leli nqaku:https://www.chenweiliang.com/cwl-453.html
Wamkelekile kwisitishi seTelegram sebhlog kaChen Weiliang ukufumana uhlaziyo lwamva nje!
📚 Esi sikhokelo sinexabiso elikhulu, 🌟Eli lithuba elinqabileyo, ungaliphoswa! ⏰⌛💨
Yabelana kwaye uthanda ukuba uyathanda!
Ukwabelana kwakho kunye nezinto ozithandayo ziyinkuthazo yethu eqhubekayo!