ubuntu12.04安装mysql黑佳伦.doc

Ubuntu 12.04安装mysql首先获取管理员权限 sudo -i1,将下载下来的文件解压到/usr/local/文件夹下tar -zxvf /usr/local/ mysql.tar.gz2,创建mysql用户和组groupadd mysqluseradd -g mysql mysql3，改变mysql目录的所有者为mysqlchown -R mysql:mysql /usr/local/mysql/4，使用mysql_install_db初始化授权表，此操作只是在初次安装时使用，如果已经安装，则跳过，负责执行后会覆盖先前的授权信息cd mysqlscripts/mysql_install_db user=mysql注意输入的文字，里面有修改root密码和启动mysql的命令为root设置密码cd /usr/local/mysql/./bin/mysqladmin -u root password yourpass之后如果修改密码则执行./bin/mysqladmin -u root -p oldpassword newpasswd执行这个命令后，需要输入root的原密码，这样root的密码将改为newpasswd5，第四步回车后，一般会报错，信息大概是，缺少共享库libaio1apt-get install libaio1 安装其共享库6，再次执行scripts/mysql_install_db user=mysql会出现一下相关信息nstalling MySQL system tables.OKFilling help tables.OKTo start mysqld at boot time you have to copysupport-files/mysql.server to the right place for your systemSee the manual for more instructions.You can start the MySQL daemon with:cd . ; ./bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.plcd ./mysql-test ; perl mysql-test-run.plPlease report any problems with the ./bin/mysqlbug script!7,配置mysql服务，然后启动cd /etc/init.dln -s /usr/local/mysql/support-files/mysql.server/etc/init.d/mysql.server start8，cd /usr/local/mysql/bon./mysql 即可启动数据库几点问题如果进入数据库后建立数据库mysql create database test;报错信息是Access denied for user localhost to database test则表示当前用户没有权限执行次操作这时候e