Click the Ubuntu system gt; System Management gt; the new software package manager searches for the jdkmysql keyword, and select the software source to be installed from the search list: configuration ~. Bashrc
Click Ubuntu system = gt; System Management = gt; New Software Package Manager to search for the jdk mysql keyword. In the search list, select software source 1: configuration ~ /. Bashrc
Click Ubuntu system => System Management => New Software Package Manager
Search for the jdk mysql keyword and select the software source to be installed from the search list.
I. Configuration ~ /. Bashrc File
Default JDK installation path/usr/lib/jvm/
In ~ /. Add it to the bashrc configuration file
JAVA_HOME =/usr/lib/jvm/java-1.5.0-sun
JAVA_BIN =/usr/lib/jvm/java-1.5.0-sun/bin
PATH = $ JAVA_HOME/bin: $ PATH
TOMCAT_HOME =/home/portal/apache-tomcat-6.0.13
CLASSPATH =.: $ JAVA_HOME/lib: $ TOMCAT_HOME/lib
Export JAVA_HOME JAVA_BIN PATH TOMCAT_HOME CLASSPATH
Ii. Configure/etc/environment
In the/etc/environment configuration file, add
PATH = "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games"
LANG = "zh_CN.UTF-8"
LANGUAGE = "zh_CN: zh"
CLASSPATH = ".:/usr/lib/jvm/java-1.5.0-sun/lib"
JAVA_HOME = "/usr/lib/jvm/java-1.5.0-sun /"
Iii. Mysql Remote Access Authorization
Mysql> grant all privileges on *. * TO admin @ localhost identified by 'Password' with grant option;
Mysql> grant all privileges on *. * TO admin @ % identified by 'Password' with grant option;
In the first sentence, an admin user is added to authorize access through the Local Machine (localhost), and the password is "password ". The second sentence is to authorize the admin user to initiate access from any other host (wildcard % ).
$ Sudo gedit/etc/mysql/my. cnf
Earlier versions
> Skip-networking => # skip-networking
New Version
> Bind-address = 127.0.0.1 => bind-address = IP address of your machine
Or comment out bind-address = 127.0.0.1 => # bind-address = 127.0.0.1
Restart MYSQL service $ sudo/etc/init. d/mysql restart
Then you can remotely access MySQL.
Iv. garbled characters in Ubuntu MySQL
$ Sudo gedit/etc/mysql/my. cnf
[Client]
Default-character-set = utf8
[Mysqld]
Default-character-set = utf8
Restart MYSQL service $ sudo/etc/init. d/mysql restart