[vc_row][vc_column width=”1/1″][vc_tour][vc_tab title=”Setting MySQL” tab_id=”1395576807-1-75″][vc_column_text]

After completed installation we need a simple setting for wordpress installing.

About <Install WordPress on pcDuino 1>, please refer to

http://learn.linksprite.com/pcduino/linux-applications/install-wordpress-on-pcduino-i/

First step: start MySQL

$sudo /etc/init.d/mysql start

Prompt “mysql start/running”, MySQL started.

Then modify the MySQL login pass word(By the way,  before writing this text I already done the all steps and set  the login pass word, but i forgot it. If you are the first time to install MySQL, during the installation the system will prompt you twice to enter the pass word. Although we forgot the password, but it does not matter we can save it.)

$ sudo vim /etc/mysql/debian.cnf

I changed the password to “ubuntu”

Step 2: Create wordpress database in MySQL

Lo-gin MySQL:

$sudo mysql -u root -p

Enter “ubuntu”, as shown:

There is another way to modify  MySQL database lo-gin password.

$update user set password=password('pcDuino') where user='root';

Now I changed pcDuino’s password to “pcDuino”, changes will take effect on the next lo-gin

Note: Each operation in  MySQL database ends with “;”

Next we have some steps to do

1. Forced to refresh memory authorization form

flush privileges;

To see the created database

$show databases;

Find MySQL automatically created a database called test example, delete the database test;

$drop database test;

Change to database mysql:

$use mysql;

Inset a wordpress users form into mysql database:

insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values ("localhost","wordpress",password('wordpress'),'','','');

Means insert some content like name and password and so on in mysql database.

Now we need to create a database for wordpress

create database wordpressDB;

Grant the right to use of wordpressDB to wordpress

grant all privileges on wordpressDB.* to wordpress;

Refresh memory authorization form

flush privileges;

Now we can exit mysql

[/vc_column_text][/vc_tab][vc_tab title=”Start Apache Service” tab_id=”1395576807-2-44″][vc_column_text]After MySQL setup

$mysql -u wordpress -p

My wordpress password is wordpress

Begin to talk about how to start the Apache service.

Start apache2，

$sudo service apache2 start

It will prompt error, we need to modify apache config file.

vim /etc/apache2/apache2.conf

Add the below code:

ServerName localhost:80

As shown below:

Execute again

$sudo service apache2 start

Now in my pcDuino have built LAMP environment,  the following post we continue to introduce how to install worpress on pcDuino.[/vc_column_text][/vc_tab][/vc_tour][/vc_column][/vc_row]