MySQL security User settings

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

MySQL security User settings

Post by hairyjim »

Hi all,

I have installed MySQL and everything is 'fresh' and all security settings are set to default.

I have noticed there are '@localhost' users set by default with no passwords and 'global' permissions.

Does anyone know of any articles which will teach me 'good security setup' for MySQL or can offer advice based on their experiences?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

This section of the MySQL manual may be of interest:
http://www.mysql.com/doc/en/Privilege_system.html

Mac
hairyjim
Forum Contributor
Posts: 219
Joined: Wed Nov 13, 2002 9:04 am
Location: Warwickshire, UK

Post by hairyjim »

Thanks. I found it a few hours after posting.

Its nice having a manula to search but when you do not know the terms used to describe what you are looking for it makes it difficult.

Cheers
James
Post Reply