先安装软件包
opkg update
opkg install php5 php5-cgi php5-fastcgi php5-mod-session php5-mod-pdo php5-mod-pdo-mysql php5-mod-mysql php5-mod-gd php5-mod-xml php5-mod-session php5-mod-zip php5-pecl-apc zoneinfo-core zoneinfo-asia
opkg install lighttpd lighttpd-mod-access lighttpd-mod-alias lighttpd-mod-cgi lighttpd-mod-fastcgi lighttpd-mod-proxy lighttpd-mod-redirect lighttpd-mod-rewrite
opkg install zlib libmysqlclient uclibcxx libreadline libncursesw mysql-server libncurses zip unzip
修改 /etc/my.cnf
tmpdir = /mnt/data/tmp/
输入
/usr/bin/mysql_install_db --force
这是创建默认的数据库，数据文件默认的地址是/mnt/data/mysql这个文件夹下
输入如下命令就可以正常启动mysql了
root@OpenWrt:~# /etc/init.d/mysqld start
Starting MySQL daemon... done
可以看到mysql已经成功启动了
当然我们也可以输入
/etc/init.d/mysqld stop
来关闭mysql，只是现在千万别输入这个命令关闭mysql！！！
输入如下命令创建mysql的密码
/usr/bin/mysqladmin -u root password 123456
或者
/usr/bin/mysqladmin -u root password '123456'
登陆数据库
mysql -u root -p
这个时候会提示你要密码。输入密码是没有任何提示符的。连*都没有哦。全看不见，盲操作之后成功进入数据库
如果一切正确你会看到的是
root@OpenWrt:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 877
Server version: 5.1.53 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
创建一个xxxx数据库
mysql> create database ucenter
-> \g
记住这里一定要以\g结束，这个命令的意思就是传送你刚才输入的字符到数据库
查看数据库
mysql> show databases
-> \g
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| ucenter |
+--------------------+
4 rows in set (0.17 sec)
这个其实是可以不用做的
输入如下命令
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.1.53, for openwrt-linux-gnu (mips) using readline 5.2
Connection id: 879
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.53 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld.sock
Uptime: 23 hours 8 min 53 sec
Threads: 1 Questions: 7974 Slow queries: 4 Opens: 894 Flush tables: 1 Open tables: 64 Queries per second avg: 0.95
--------------
你会看到当前数据库的一些状况！！！！