mysql機能要約
4391 ワード
python mysqlプログラミング:
SQL注入
表示
取引
索引
アカウント管理
マスタスレーブ構成
conn = mysql.connect
cursor = conn.cursor()
SQL cursor.execute(sql )
cursor.close()
conn.close()
SQL注入
SQL , SQL , SQL , 。
, SQL :
SQL execute
, %s ,
for example:params = [find_name]
# select , :
count = cs1.execute('select * from goods where name=%s', params)
表示
, , ,
, 。
:
,
, ,
,
:create view as select ;
:show tables;
:select * from ;
:drop view ;
取引
: innodb ,
: SQL , , 。
:
:
:
:
: commit
rollbakc
:
:begin start transaction
:commit
:rollback
:
1、 , insert、update、delete
2、 ,mysql , set autocommit = 0
3、 :
索引
: (InnoDB ),
。 。
:create index idx_ on ( ( ))
:show index from
:drop index idx_ on
: , , , , ,
, , 2 n 。
アカウント管理
:
1. :, mysqld, ; root, , 2 、
2. :
3. :
4. :
5. :
:** flush privileges;
:select host,user,authentication_string from user;(user mysql )
:show grants for ' '@' ';
:grant on . to ' '@' ' identified by ' ' WHIH GRANT OPTION
:create、alter、drop、insert、update、delete、select all privileges
** WHIH GRANT OPTION ,
:grant on . to ' '@' '
:revoke on . from ' '@' ';
:update user set authentication_string= PASSWORD(' ') where user = ' ';
:drop user ' '@' ';
マスタスレーブ構成
1
sql
mysqldump -uroot -pmysql --all-databases --lock-all-tables > ~/master_db.sql
2 --
mysql -uroot -pmysql < master_db.sql
3 server_id
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# bind-address = 127.0.0.1
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
sudo service mysql restart
4.
IP ifconfig : 192.168.164.91
mysql> show master status;
File Position
mysql root@(none):jd> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
mysql-bin.000035 | 154 | | |
+------------------+---------
5.
GRANT REPLICATION SLAVE ON *.* TO 'slave'@'%' identified by 'slave';
FLUSH PRIVILEGES;
6.
mysql > stop slave;
change master to master_host='192.168.164.91', master_user='slave',
master_password='slave',master_log_file='mysql-bin.000035', master_log_pos=154;
mysql> start slave
mysql> show slave status;
> reset slave
MAC MySQL
brew services start mysql ( )
brew services stop mysql ( )