Tag Archives: mysql
Installation and Basic Configuration Apache, MySQL and PHP on CentOS 5.1 (64 bit)
These are the simple steps to Install and do basic configuration Apache 2.2.3, MySQL 5.0.22 and PHP on a base install CentOS 5.1 x86_64.
Securing MySQL Installation
This is the step for standard security implementation to a fresh MySQL installation; it will;
Give the root password
Remove anonymous users
Disallow root login remotely
Remove test database and access to it
Reload privilege tables
If you answer Y (Yes) to all question. Notice the error log on the output below is because this is not the first time I [...]
Adding MySQL User
This one from MySQL Docs;
mysql --user=root mysql -p
Insert your MySQL root password, it will jump you to mysql database (keeping user account information);
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
-> IDENTIFIED BY 'some_pass' WITH [...]
Nginx, MySQL, PHP in CentOS 5.1 (x86_64)