ServerSignature Linux Community Support Blog Page

Create a mysql database and User
mysql> CREATE DATABASE database1;
For creating a new user with all privileges (use only for troubleshooting), at mysql prompt type:
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘yourusername’@'localhost’ IDENTIFIED BY ‘yourpassword’ WITH GRANT OPTION;
For creating a new user with fewer privileges (should work for most web applications) which can only use the [...]