Here is a quick guide to creating a new MYSQL database, adding a user, and then finally a simple table. I will be using debian/ubuntu as the host system. First create the database. Login as the root user. Create the database user. Now grant the new user permissions on the new database. Don’t forget to… Continue reading Create A New MYSQL Database and User
Tag: mysql
Set Timezone for MYSQL / PHP
After setting system time, I discovered that mysql and php services didn’t also update the timezone settings. Here’s how to make sure they also reflect the correct timezone. First locate all the php.ini files in /etc now edit these files and add the timezone info add this to the [Date] block: For mysqld portion, first… Continue reading Set Timezone for MYSQL / PHP