MySQL裝置及常用SQL

1.裝置并啟用MYSQL

rpm -Uvh  http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm yum -y install mysql-community-server systemctl start mysqld systemctl enable mysqld

2.獲取并修正MYSQL的root暗碼

grep 'temporary password' /var/log/mysqld.log mysql -uroot -p 修正MySQL的root用戶的初始暗碼。 set global validate_password_policy=0; 修正安全策略 ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678';

3.常用 SQL

檢查數(shù)據(jù)庫

show database;

創(chuàng)立數(shù)據(jù)庫

create database database_name;

切換數(shù)據(jù)庫

use database_name;

檢查某數(shù)據(jù)庫中所有的數(shù)據(jù)表

show table;

創(chuàng)立數(shù)據(jù)表

View Code

檢查數(shù)據(jù)表結(jié)構(gòu)

describe  table_name; --縮寫: desc

檢查數(shù)據(jù)表中的記載

select  * from  table_name;

-- 去重復(fù)

select distinct name from table_name

往數(shù)據(jù)表中添加數(shù)據(jù)記載

INSERT INTO table_name

VALUES('puffball','Diane','hanst','f','1999-03-23',NULL);

指定屬性

insert into user3 (name) value('asfjl');

刪除數(shù)據(jù)

delete from table_name where name='puffball';

修正數(shù)據(jù)

update table_name set name='wang' where owner='haha'

運用RDS MySQL和ECS建立個人博客

場景將供給一臺根底環(huán)境為CentOS的ECS（云服務(wù)器）和一臺RDS MySQL版數(shù)據(jù)庫實例。咱們將會在這臺服務(wù)器裝置Apache+PHP+WordPress網(wǎng)站環(huán)境，結(jié)合RDS MySQL版數(shù)據(jù)庫實例協(xié)助您快速建立自己的云上博客。

咱們的wordpress博客系統(tǒng)基于lnmp或lamp環(huán)境，即linux、網(wǎng)頁服務(wù)、數(shù)據(jù)庫服務(wù)、php服務(wù)組成。運用ECS和RDS咱們將事務(wù)完成云上的布置，將原本all in one的架構(gòu)，將數(shù)據(jù)庫服務(wù)獨立，布置在云數(shù)據(jù)庫RDS上，其他的服務(wù)，布置在ECS云服務(wù)器上。

布置裝備RDS云數(shù)據(jù)庫

1.創(chuàng)立數(shù)據(jù)庫連接賬號

2.創(chuàng)立博客事務(wù)所運用的數(shù)據(jù)庫

布置ECS環(huán)境

裝置apache環(huán)境

yum -y install httpd httpd-manual mod_ssl mod_perl mod_auth_mysql systemctl start httpd.service

裝置php環(huán)境

yum -y install php php-mysql gd php-gd gd-devel php-xml php-common php-mbstring php-ldap php-pear php-xmlrpc php-imap echo "" > /var/www/html/phpinfo.php systemctl restart httpd

測驗拜訪：phpinfo.php頁面，成功顯示

裝置和裝備WordPress

裝置WordPress

yum -y install wordpress cd /usr/share/wordpress ln -snf /etc/wordpress/wp-config.php wp-config.php mkdir /var/www/html/wp-blog mv * /var/www/html/wp-blog/

修正wp-config.php裝備文件

sed -i 's/database_name_here/wordpress/' /var/www/html/wp-blog/wp-config.php sed -i 's/username_here/test_user/' /var/www/html/wp-blog/wp-config.php sed -i 's/password_here/Password1213/' /var/www/html/wp-blog/wp-config.php sed -i 's/localhost/data/' /var/www/html/wp-blog/wp-config.php systemctl restart httpd

初始化WordPress

裝置布置成功，拜訪后臺