mysql在linux的安装
在linux(ubuntu)下安装mysql:version：5.0.*
tar.gz 二进制包
shell> adduser mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
--------------------
1、修改为UTF-8编码
shell> cp support-files/my-medium.cnf /etc/my.cnf
修改etc下的my.cnf
在和下面添加：
default-character-set=utf8
2、删除对远程访问的dns回查（不然远程会很慢）
修改etc下的my.cnf
在下增加：
skip-name-resolve
-----------------
启动mysql：
shell> bin/mysqld_safe --user=mysql &
停止mysql：
shell> bin/mysqladmin -u root -p shutdown
登录数据库：
shell> bin/mysql -u root -p
---------------
添加远程登录权限：
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
mysql>flush privileges;
mysql>select 'host','user' from user where user='root';
或：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.1' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
页:
[1]