系統檢測 : sudo apt-get update
1、配置資訊
Ubuntu 系統 64位 mysql 5.5 jdk1.7 tomcat6
2、配置JDK
sudo mkdir /usr/lib/jvm
sudo tar zxvf jdk-tar.gz -C /usr/lib/jvm
cd /usr/lib/jvm
sudo mv jdk1.7.0_21 java
vim ~/.bashrc
export JAVA_HOME=/usr/lib/jvm/java
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib
export PATH=${JAVA_HOME}/bin:$PATH
sudo update-alternatives --install /usr/bin/java java /usr/lib/jvm/java/bin/java 300
sudo update-alternatives --install /usr/bin/javac javac /usr/lib/jvm/java/bin/javac 300
sudo update-alternatives --install /usr/bin/jar jar /usr/lib/jvm/java/bin/jar 300
sudo update-alternatives --install /usr/bin/javah javah /usr/lib/jvm/java/bin/javah 300
sudo update-alternatives --install /usr/bin/javap javap /usr/lib/jvm/java/bin/javap 300
:wq和:x是存盤退出
選擇jdk
sudo update-alternatives --config java
tomcat啟動的時候
Permission denied解決方法
chmod u+x *.sh
show variables like \'character%\';
sudo vi /etc/resolv.conf
sudo source /etc/resolv.conf
resolvonf -u
3、linux安裝mysql
sudo apt-get install mysql-server
mysql -u root -p
建立使用者
create user \'frank\'@\'localhost\';
set password for \'frank\'@\'localhost\' = password(\'abcdefg\');
create database sampledb;
配置使用者權限
grant all privileges on sampledb.* to \'frank\'@\'localhost\';
source 檔案
導出資料:mysqldump -hlocalhost -u user -p password >XX.sql
連結資料庫:mysql -h localhost - u root
mysql中文亂碼解決
這裡簡單明了地說下:
對于mysql5.5版本,需要在/etc/mysql/my.cnf做如下修改:
[client]下添加:default-character-set = utf8
[mysqld]下添加:character-set-server = utf8
對于mysql5.5之前的版本,做如下修改:
在[client] 和 [mysqld]下都添加一行
default-character-set = utf8
如果在mysql5.5 版本中也這麼配置會導緻mysql服務起不來。