On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.comwrote:
hearing from many admins that MySQL expects and needs there to be
three accounts for root. Them being 'localhost', 127.0.0.1, and
hostname. Is this false information?
Totally false. It's convenient, and probably all
If you only want root to be able to log in locally then you only need
'root'@'localhost' unless you are using tcp connections.
regards
John
On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens carlosw...@gmail.comwrote:
Today I installed MySQL 5.1.45-1 on my production server and it
recommended
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman vegiv...@tuxera.be wrote:
On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.com
wrote:
hearing from many admins that MySQL expects and needs there to be
three accounts for root. Them being 'localhost', 127.0.0.1, and
On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens carlosw...@gmail.comwrote:
mysql CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'holla';
mysql GRANT ALL PRIVILEGES ON *.* TO 'carlos'@'localhost' WITH GRANT
OPTION;
Pretty much. It's also a good idea to give that user SUPER privileges, as
Today I installed MySQL 5.1.45-1 on my production server and it
recommended that I run the following:
/usr/bin/mysql_secure_installation
When I ran this, it simply guided me to do the following:
- set root password
- disable remote login for root
- remove 'anonymous' user accounts
- delete