PHP Archives - THEMWEBS

MySQL DB Installation notes on Ubuntu 14.04 LTS

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

Alternatively you can run:

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

You can start the MySQL daemon with:

You can test the MySQL daemon with mysql-test-run.pl

Changing language settings in phpMyAdmin

I recently installed XAMPP 1.7.7 on my machine at work. I needed to develop WordPress themes locally.

So as one does I opened up phpMyAdmin to set up a database for the first time and shock horror horror everything was written in German.  If you’ve encountered this problem here’s what you do…

Open up the  config.inc.php file found inside of the system folders and paste in this bit of code…

/* Set language to English*/
$cfg['Lang'] = 'en-utf-8';

Location of file on my machine C:/XAMPP/phpMyAdmin/config.sample.inc

I hope somebody finds this information useful.

Tags | phpMyAdmin, XAMPP