Uhla lwemibhalo ye-athikili
indlela yokuphathaMySQL database? Ukuphathwa komyalo we-SSHMySQLiseva
MySQL Ukuphatha
Qala futhi umise iseva ye-MySQL
Okokuqala, sidinga ukuhlola ukuthi iseva ye-MySQL iphezulu yini ngokusebenzisa umyalo olandelayo:
ps -ef | grep mysqld
Uma i-MySql isivele iqalile, umyalo ongenhla uzokhipha uhlu lwezinqubo ze-mysql, uma i-mysql ingaqalwanga, ungasebenzisa umyalo olandelayo ukuqala iseva ye-mysql:
root@host# cd /usr/bin ./mysqld_safe &
Uma ufuna ukuvala iseva ye-MySQL esebenzayo njengamanje, ungenza umyalo olandelayo:
root@host# cd /usr/bin ./mysqladmin -u root -p shutdown Enter password: ******
Izilungiselelo Zomsebenzisi we-MySQL
Uma udinga ukwengeza umsebenzisi we-MySQL, udinga nje ukwengeza umsebenzisi omusha etafuleni lomsebenzisi ku-database ye-mysql.
Okulandelayo isibonelo sokwengeza umsebenzisi, igama lomsebenzisi isivakashi, igama eliyimfihlo lithi guest123, futhi umsebenzisi ugunyazwe ukwenza imisebenzi ethi KHETHA, UKUFAKA NOKUBUYEKEZA:
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)
Lapho ungeza umsebenzisi, sicela uqaphele ukuthi iphasiwedi ibethelwe kusetshenziswa umsebenzi we-PASSWORD() ohlinzekwa yi-MySQL.Ungabona kulesi sibonelo esingenhla ukuthi iphasiwedi yomsebenzisi ebethelwe ithi: 6f8c114b58f2ce9e.
Qaphela:Ku-MySQL 5.7, igama eliyimfihlo letafula lomsebenzisi lithathelwe indawo yii-authentication_string,
Qaphela:Qaphela isidingo sokusebenzisa FLUSH AMALUNGELO isitatimende.Ngemuva kokuthi lo myalo usukhishiwe, ithebula lesibonelelo lizolayishwa kabusha.
Uma ungawusebenzisi lo myalo, ngeke ukwazi ukusebenzisa umsebenzisi osanda kwakhiwa ukuze uxhume kuseva ye-mysql ngaphandle kokuthi uqale kabusha iseva ye-mysql.
Lapho udala umsebenzisi, ungacacisa izimvume zomsebenzisi. Kukholomu yemvume ehambisanayo, isethe ukuze ithi 'Y' esitatimendeni sokufaka. Uhlu lwezimvume zomsebenzisi lumi kanje:
- Khetha_okuyimfihlo
- Insert_priv
- Update_priv
- Delete_priv
- Dala_imfihlo
- drop_priv
- Layisha kabusha_okuyimfihlo
- shutdown_priv
- Process_priv
- Ifayela_priv
- Grant_priv
- Izithenjwa_priv
- Inkomba_priv
- Alter_priv
Enye indlela yokwengeza abasebenzisi ngomyalo we-GRANT we-SQL. Umyalo olandelayo uzongeza umsebenzisi u-zara kusizindalwazi esishiwo TUTORIALS, futhi igama-mfihlo 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';
Umyalo ongenhla uzodala irekhodi lolwazi lomsebenzisi kuthebula lomsebenzisi ku-database ye-mysql.
Isaziso: Izitatimende ze-MySQL SQL ziqedwa nge-semicolon (;).
/etc/my.cnf ukucushwa kwefayela
Ngaphansi kwezimo ezijwayelekile, awudingi ukushintsha ifayela lokumisa, ukucushwa okuzenzakalelayo kwefayela kungokulandelayo:
[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
Efayelini lokumisa, ungacacisa uhla lwemibhalo lapho kugcinwa khona amafayela elogi anephutha ahlukene. Ngokuvamile, awudingi ukushintsha lokhu kulungiselelwa.
Imiyalo yokuphatha i-MySQL
Okulandelayo kubala imiyalo evame ukusetshenziswa ohlelweni lokusebenzisa i-Mysql database:
- UKUSETSHENZISWA Igama lokugcina idatha :
Khetha isizindalwazi se-Mysql esizosetshenziswa Ngemva kokusebenzisa lo myalo, yonke imiyalo ye-Mysql ingeyalesi sizindalwazi kuphela.mysql> use chenweiliang; Database changed
- BONISA IMINININGWANE:
Iklelisa uhlu lwesizindalwazi sohlelo lokuphathwa kwesizindalwazi se-MySQL.mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | chenweiliang | | cdcol | | mysql | | onethink | | performance_schema | | phpmyadmin | | test | | wecenter | | wordpress | +--------------------+ 10 rows in set (0.02 sec)
- BONISA AMATHEBULA:
Bonisa wonke amathebula esizindalwazi esicacisiwe Ngaphambi kokusebenzisa lo myalo, udinga ukusebenzisa umyalo wokusebenzisa ukuze ukhethe isizindalwazi esizosetshenziswa.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 AMAKHOLUMU ASUKA ishidi le-data:
Bonisa izibaluli zethebula ledatha, izinhlobo zezibaluli, ulwazi oluyinhloko oluyinhloko, noma ngabe LU-NULL, inani elizenzakalelayo 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 INHLOKO KUSUKA ishidi le-data:
Bonisa imininingwane yenkomba enemininingwane yethebula ledatha, okuhlanganisa UKHIYE OWUNGU-PRIMARY (ukhiye oyinhloko).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 ISIMO SETHEBULA NJENGETHI [KUSUKA ku-db_name] [NJENGA 'iphethini'] \G:
Lo myalo uzokhipha ukusebenza kanye nezibalo zohlelo lokuphathwa kwedatha ye-Mysql.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,查询结果按列打印
I-Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabiwe "Indlela yokuphatha i-MySQL database? Imiyalo ye-SSH yokuphatha amaseva e-MySQL", izokusiza.
Siyakwamukela ukwabelana ngesixhumanisi salesi sihloko:https://www.chenweiliang.com/cwl-453.html
Uyemukelwa esiteshini seTelegram sebhulogi ka-Chen Weiliang ukuze uthole izibuyekezo zakamuva!
📚 Lo mhlahlandlela uqukethe inani elikhulu, 🌟Leli ithuba eliyivelakancane, ungaphuthelwa! ⏰⌛💨
Yabelana futhi uthanda uma uthanda!
Ukwabelana kwakho nokuthanda kwakho kuyisisusa sethu esiqhubekayo!