Once installation of XAMPP is complete, database MySQL is also ready to use.
When you create a system where a database is used, you need to set up MySQL after having installed XAMPP.
Setting Up Character Set
First, set up character set.
Select ‘etc’ folder in ‘xamppfiles’ in the installed XAMPP folder (if default setting, XAMPP folder is under Applications).
The, open ‘my.cnf’ file by note pad.
*If you modify some other lines by mistake, there is possibility that MySQL does not work.
So, it is recommended that you copy the file “my.cnf” and save it for backup.
By referring the following code, in [client] section, add [default-character-set=utf8].
And at the end of [mysqlId] section, add [character-set-server=utf8].
（Before modification） [client] #password = your_password port = 3306 socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock （After modification） [client] default-character-set=utf8 #password = your_password port = 3306 socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
（Before modification） [mysqld] user = mysql port=3306 ... ... （After modification） [mysqld] user = mysql port=3306 ... ... character-set-server=utf8
That’s all for setting up character set.
Now let’s start to run MySQL!
First, open the folder where XAMPP is installed (i.e. xampp folder directly under Applications by default).
Double-click the file “manager-osx.app”, which is at the bottom of xampp folder.
Operation of MySQL
Now that MySQL has run, log in to MySQL and try some operations.
Select ‘Macintosh HD’=>’Applications’=>’Utilities’ and run ‘Terminal.app’.
After run Terminal, the following window will open.
You will run MySQL by using this “Terminal”.
To begin with, enter the command below after ‘ $ ‘ which is shown at the end on terminal screen, and click “Enter” key.
“cd” is the command to specify which directory to move to.
The above description specifies “bin” folder under “xamppfiles” folder under “XAMPP” folder under Applications.
If you have successfully moved to the directory, the command prompt screen will be as below.
./mysql -u root
Once you have successfully logged in to MySQL, screen will be as below.
Data management unit in MySQL is a database.
For example, when you collectively manage data in a book management system, you would need to store all the tables related to the book management system in the same “database”.
To begin with, let’s take a look at what databases are currently available in the MySQL environment.
Enter the command as below and click “Enter” key.
mysql > show databases;
‘techfun’ is the name of a database. You can specify another name, of course.
mysql > create database techfun;
Let’s check if the specified database has been really created by running the command below.
mysql > show databases;
Do you see the database ‘techfun’ shown on screen?
Select the database that you have just created.
You can select the database to use by running the command below.
mysql > use database_name;
If you see the message “Database changed” on command prompt screen, it indicates that the specified database has been selected with no problem.
How to enter a long SQL statement.
When you enter commands on command prompt, it is possible to insert line feeds in the middle of a statement.
For example, if you enter ‘mysql > show databases’ without a ” ; ” at the end and press “Enter” key, command prompt screen will be as below.
mysql > show databases ->
This means that one statement still continues.
When you enter ” ; ” after an arrow and press “Enter” key, the command runs.
This function allows you to divide a long SQL statement into several lines by inserting line feeds. You will get the same execution result from this way of writing a command.
mysql > show -> databases -> ;
That’s all for setting up MySQL.