mysql5.5 linux安装

缺少库
shell> apt-cache search libaio # search for info

shell> apt-get install libaio1 # install library

安装并使用MySQL二进制分发版的基本命令是:

shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
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
# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf

 

启动服务器
shell> bin/mysqld_safe --user=mysql &

或

shell> bin/mysqld_safe --user=mysql --log-bin &

shell> bin/mysqld  --user=root --log-bin

shell>support-files/mysql.server start

/***

--binlog-do-db= db_name   --binlog-ignore-db= db_name **/

关闭服务器:
 shell> bin/mysqladmin -u root shutdown

shell>support-files/mysql.server stop

shell>pkill mysqld

开机启动

shell> cp support-files/mysql.server /etc/init.d/mysql.server

 

查看日志功能是否开启

 shell> bin/mysql -uroot -p123456
    mysql> show variables like 'log_%'; 

 

数据库情况

shell> bin/mysqlshow

某数据库表情况

shell> bin/mysqlshow dbname

 

为匿名账户设置密码

shell> bin/mysql -u root
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd')

----host_name通过shell>hostname命令取得---

方法2

shell> bin/mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpwd')
    ->     WHERE User = '';
mysql> FLUSH PRIVILEGES;

删除匿名账户

shell> bin/mysql -u root
mysql> DELETE FROM mysql.user WHERE User = '';
mysql> FLUSH PRIVILEGES;

为root账户设置密码

shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');

 

配置文件式开启二进制日志

vi编辑打开mysql配置文件

    shell> vi /usr/local/mysql/etc/my.cnf

    在[mysqld] 区块

    设置/添加 log-bin=mysql-bin  确认是打开状态(值 mysql-bin 是日志的基本名或前缀名)；

    重启mysqld服务使配置生效

    shell>pkill mysqld

    shell>bin/mysqld_safe --user=mysql &