C-extra.com - MySQL - Authentification Password and Protection

Page Web Française

Subject Security Date 2010-06-12

Title MySQL - Authentification Password and Protection Section Dev Reseau

Article

MySQL Server Authentication

When you install a MySQL server with a Linux distribution Fedora 12 FC12 ou FreeBSD, the Password Administrator « root » is empty or white. The first things to do is enter a Password MySQL Server security.

Necessary softwares and servers:

Operating system: Fedora 12 FC12 or FreeBSD or another Unix.

Components or Packages: MySQL

For installation MySQL for FreeBSD see the articles below :

FreeBSD - Install and Configure version 7.3-RELEASE
FreeBSD - Install and Configure version 8.1-RELEASE

See the article on the installation of Webmin - System and server administration

With Webmin the Servers section then MySQL Database Server start MySQL Server and then click on the icon Change Administration Password.

Change Administration Password

Enter simply the Administrator Password « root » MySQL !

For earlier versions of Webmin-1.420 proceed as indicated below.

With Webmin the Servers section then MySQL Database Server and then click on the icon User Permissions.

Select all. | Invert selection. | Add a new interface.

User	Hosts	Encrypted password	Permissions
Anonymous	localhost		None
Anonymous	nameserveur.domain.com		None
Nom-site	localhost		Select
root	localhost		All
root	nameserveur.domain.com		All
root	127.0.0.1		All

Select all. | Invert selection. | Add a new interface.

Click on the first « root » having for user localhost.

This form is obtained:

Edit User

MySQL user details

Username	Anonymous user
Password	None Don’t change Set to..
Hosts	Any
Permissions

Enter password « root » for user: root@localhost

After it is simply necessary to be authenticated for Webmin, it asks only once.

This form is obtained:

MySQL Database Server

Webmin needs to know your MySQL administration login and password in order to manage your database.
Please enter your administration username (usually root) and password below.

MySQL Login

Login
Password

The full MySQL error message was : connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Once again this operation for the Domain user root@nameserveur.domain.com but this second time Webmin will not require authentication and for Loopback Adress IP root@127.0.0.1 .

Author

Eric Douzet

Infologism.com

Select table data
Insert table data
Update table data
Delete table data
Create tables
Drop tables
Reload grants
Shutdown database
Manage processes
File operations
Grant privileges
Reference operations
Manage indexes
Alter tables
Show databases
Superuser
Create temp tables
Lock tables
Execute
Slave replication
Client replication
Create View
Show View
Create Routine
Alter Routine
Create User