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 [...]