Linux Server – Pittsburgh Computers and Programming Company

Create A New MYSQL Database and User

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

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

Change Timezone on Raspian / Debian / Ubuntu

Here’s a quick and easy way to change the timezone configuration on Raspian / Debian / Ubuntu server, but will probably work on other linux flavors as well. First, lets see what our current configuration is: To get a list of all the supported time-zones: And something like this to grep for relevant ones: Next,… Continue reading Change Timezone on Raspian / Debian / Ubuntu