Tusitusiga Tusitusiga
auala e pulea aiMySQL database? SSH pulega puleMySQLsapalai
MySQL Pulega
Amata ma taofi le MySQL server
Muamua, e tatau ona tatou siaki pe o loʻo i luga le server MySQL e ala i le faʻatinoina o le poloaiga lenei:
ps -ef | grep mysqld
Afai ua uma ona amata MySql, o le poloaiga o loʻo i luga o le a faʻaalia ai se lisi o faiga mysql, pe a le amataina mysql, e mafai ona e faʻaogaina le poloaiga lenei e amata ai le mysql server:
root@host# cd /usr/bin ./mysqld_safe &
Afai e te manaʻo e tapuni le MySQL server i le taimi nei, e mafai ona e faʻatinoina le poloaiga lenei:
root@host# cd /usr/bin ./mysqladmin -u root -p shutdown Enter password: ******
MySQL Fa'aoga Fa'atonu
Afai e te manaʻomia le faʻaopoopoina o se tagata faʻaoga MySQL, naʻo lou manaʻomia e faʻaopoopo le tagata fou i le laulau faʻaoga ile mysql database.
O se fa'ata'ita'iga lea o le fa'aopoopoina o se tagata fa'aoga, o le igoa fa'aoga o le malo, o le uputatala o le guest123, ma ua fa'atagaina le tagata fa'aoga e fa'atino galuega FILIFILI, INSERT ma UPDATE:
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)
Pe a faʻaopoopo se tagata faʻaoga, faʻamolemole matau o le upu faʻamaonia o loʻo faʻailogaina e faʻaaoga ai le PASSWORD () galuega na saunia e MySQL.E mafai ona e vaʻai i le faʻataʻitaʻiga o loʻo i luga o le faʻailoga faʻaoga faʻaoga o le: 6f8c114b58f2ce9e.
Manatua:I MySQL 5.7, ua suia le upu faataga o le laulau faʻaoga eauthentication_string.
Manatua:Ia nofouta i le manaʻoga e faʻatino FA'AMATALAGA FLUSH fa'amatalaga.A mae'a le fa'atonuga, o le a toe uta le laulau fa'ameaalofa.
Afai e te le faʻaogaina lenei faʻatonuga, o le a le mafai ona e faʻaogaina le tagata fou fou e faʻafesoʻotaʻi i le mysql server sei vagana ua e toe amataina le mysql server.
A'o faia se tagata fa'aoga, e mafai ona e fa'ailoa mai fa'atagaga mo le tagata fa'aoga.
- Select_priv
- Insert_priv
- Update_priv
- Delete_priv
- Create_priv
- drop_priv
- Toe uta_priv
- shutdown_priv
- Process_priv
- File_priv
- Grant_priv
- References_priv
- Index_priv
- Alter_priv
O le isi auala e fa'aopoopo ai tagata fa'aoga e ala lea i le GRANT command of SQL. O le isi fa'atonuga o le a fa'aopoopo le tagata fa'aoga zara i le fa'amaumauga tu'ufa'atasia TUTORIALS, ma o le fa'aupuga o le 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';
O le faʻatonuga o loʻo i luga o le a fatuina ai se faʻamaumauga faʻamatalaga tagata faʻaoga i le laulau faʻaoga ile mysql database.
Fa'aaliga: O faʻamatalaga MySQL SQL e faʻamutaina i se semicolon (;).
/etc/my.cnf faila faila
I lalo o tulaga masani, e te le manaʻomia le suia o le faila faʻatulagaina, o le faʻaogaina o le faila e faʻapea:
[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
I totonu o le faila faila, e mafai ona e faʻamaonia le lisi o loʻo teuina ai faila log error eseese.. I se tulaga masani, e te le manaʻomia le suia o nei faʻatonuga.
Poloaiga e pulea MySQL
O loʻo lisiina i lalo tulafono e masani ona faʻaaogaina i le faʻaogaina o le Mysql database:
- Faʻaaoga igoa teuina o faamatalaga :
Filifili le Mysql database e fa'agaioia.A uma ona fa'aogaina lenei fa'atonuga, o poloaiga uma a Mysql e na'o lenei fa'amaumauga.mysql> use chenweiliang; Database changed
- FA'AALI FA'AVAE FA'AVAE:
Lisi le lisi o faʻamaumauga o le MySQL database management system.mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | chenweiliang | | cdcol | | mysql | | onethink | | performance_schema | | phpmyadmin | | test | | wecenter | | wordpress | +--------------------+ 10 rows in set (0.02 sec)
- FA'AALI LA'AU:
Fa'aali laulau uma o fa'amaumauga fa'amaumauga. A'o le'i fa'aogaina lenei fa'atonuga, e mana'omia lou fa'aogaina o le fa'atonuga fa'aoga e filifili ai le database e fa'agaioia.mysql> use chenweiliang; Database changed mysql> SHOW TABLES; +------------------+ | Tables_in_chenweiliang | +------------------+ | employee_tbl | | chenweiliang_tbl | | tcount_tbl | +------------------+ 3 rows in set (0.00 sec)
- FAAALI KOLUMA MAI pepa fa'amatalaga:
Fa'aali uiga o le laulau fa'amaumauga, ituaiga uiga, fa'amatalaga autu autu, pe o le NULL, fa'aletonu le tau ma isi fa'amatalaga.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)
- FAAALI FAILAUGA MAI pepa fa'amatalaga:
Fa'aali atu fa'amatalaga fa'asinoala auiliili o le laulau fa'amaumauga, e aofia ai KI FA'ATAU (primary key).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)
- FA'AALI LE TULAGA FA'AVAE PEI [MAI le db_name] [PEI 'mamanu'] \G:
O lenei poloaiga o le a faʻaalia ai le faʻatinoga ma fuainumera o le Mysql database management system.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,查询结果按列打印
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) faasoa "E faʻafefea ona pulea MySQL database? SSH Poloaiga e Pulea MySQL Servers", o le a fesoasoani ia te oe.
Fa'afeiloa'i e fa'asoa le so'otaga o lenei tusitusiga:https://www.chenweiliang.com/cwl-453.html
Faʻafeiloaʻi i le Telegram channel o le blog a Chen Weiliang e maua ai faʻamatalaga lata mai!
📚 O lenei taʻiala o loʻo i ai le taua tele, 🌟O se avanoa e seasea maua, aua le misia! ⏰⌛💨
Faasoa ma fiafia pe a e fiafia i ai!
O lau fefa'asoaa'i ma le fiafia o la matou fa'aosofiaga faifaipea!