欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

MySQL的安全問題從安裝開始說起

 更新時間:2013年04月10日 17:46:39   作者:  
本篇文章小編為大家介紹,關于MySQL的安全問題從安裝開始說起,有需要的朋友可以參考一下
當你安裝 MySQL 完后、會有個提示:

[root@localhost Desktop]# rpm -ivh MySQL-server-5.5.28-1.rhel5.i386.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]


PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'


Alternatively you can run:

/usr/bin/mysql_secure_installation

**對于這 2 種方式、我個人認為、mysql_secure_installation 比較好用***

which will also give you the option of removing the test
databases and anonymous user created by default
. This is
strongly recommended for production servers.


**我覺得、這里的關鍵應該是能夠把匿名用戶給刪掉***
See the manual for more instructions.

Please report any problems with the /usr/bin/mysqlbug script!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for

them. This is intended only for testing, and to make the installationgo a bit smoother.

You should remove them before moving into a production environment

**匿名用戶的危害****

所以、生產(chǎn)環(huán)境請務必刪之?。?/STRONG>

我選擇 mysql_secure_installation


[root@localhost Desktop]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...


Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

You already have a root password set, so you can safely answer 'n'.

Change the root password? [Y/n] n
... skipping.

By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
... Success!

Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
... skipping.

By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] n
... skipping.


Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.


Reload privilege tables now? [Y/n] y
... Success!


Cleaning up...


All done! If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!

相關文章

  • mysql中的int(10)int(20)分別代表什么意思

    mysql中的int(10)int(20)分別代表什么意思

    這篇文章主要介紹了mysql中的int(10)int(20)分別代表什么意思,具有很好的參考價值,希望對大家有所幫助。如有錯誤或未考慮完全的地方,望不吝賜教
    2023-05-05
  • Mysql樹形結構的數(shù)據(jù)庫表設計方案

    Mysql樹形結構的數(shù)據(jù)庫表設計方案

    樹形結構對大家來說應該都不陌生,在日常開發(fā)中經(jīng)常會遇到,下面這篇文章主要給大家介紹了關于Mysql樹形結構的數(shù)據(jù)庫表設計的相關資料,文中通過示例代碼的非常詳細,需要的朋友可以參考下
    2021-09-09
  • java連接mysql底層封裝詳解

    java連接mysql底層封裝詳解

    這篇文章主要介紹了java連接mysql底層封裝,文中示例代碼介紹的非常詳細,具有一定的參考價值,感興趣的小伙伴們可以參考一下
    2019-10-10
  • windows下MySQL免安裝版配置教程mysql-5.6.51-winx64.zip版本(最新安裝教程)

    windows下MySQL免安裝版配置教程mysql-5.6.51-winx64.zip版本(最新安裝教程)

    這篇文章主要介紹了windows下MySQL免安裝版配置教程mysql-5.6.51-winx64.zip版本(最新安裝教程),本文通過圖文并茂的形式給大家介紹的非常詳細,對大家的學習或工作具有一定的參考借鑒價值,需要的朋友可以參考下
    2023-01-01
  • Mysql、Oracle中常用的多表修改語句總結

    Mysql、Oracle中常用的多表修改語句總結

    這篇文章主要給大家介紹了關于Mysql、Oracle中常用的多表修改語句的相關資料,文中通過示例代碼介紹的非常詳細,對大家的學習或者工作具有一定的參考學習價值,需要的朋友們下面隨著小編來一起學習學習吧
    2020-12-12
  • 如何恢復MySQL主從數(shù)據(jù)一致性

    如何恢復MySQL主從數(shù)據(jù)一致性

    MySQL主從數(shù)據(jù)一致性怎么恢復,MySQL主從數(shù)據(jù)庫的數(shù)據(jù)不一致,猜測備庫在同步過程中出現(xiàn)了問題,現(xiàn)在的問題很明確,就是如何恢復主從庫數(shù)據(jù)的一致性,下文為大家分享解決方法,感興趣的小伙伴們可以參考一下
    2016-04-04
  • MySQL一個索引最多有多少個列?真實的測試例子

    MySQL一個索引最多有多少個列?真實的測試例子

    MySQL一個索引最多有多少個列?下面是具體的實現(xiàn)代碼。
    2009-07-07
  • MySQL由淺入深探究存儲過程

    MySQL由淺入深探究存儲過程

    存儲過程就是一條或者多條SQL語句的集合,可以視為批文件,它可以定義批量插入的語句,也可以定義一個接收不同條件的SQL,下面這篇文章主要給大家介紹了關于MySQL中存儲過程的相關資料,需要的朋友可以參考下
    2022-07-07
  • Centos下 修改mysql密碼的方法

    Centos下 修改mysql密碼的方法

    這篇文章主要介紹了Centos下 修改mysql密碼的方法,需要的朋友可以參考下
    2017-02-02
  • 一文帶你了解MySQL之約束

    一文帶你了解MySQL之約束

    在SQL標準中,一共規(guī)定了6種不同的約束,包括非空約束,唯一約束和檢查約束等,而在MySQL中是不支持檢查約束的,所以這篇文章先對其余5種約束做一個詳解和練習,需要的朋友可以參考下
    2023-06-06

最新評論