mysql 5.5.18 install, missing user table
Posted: 2012/01/09 13:05:28
Hi, I am new install mysql 5.5.18. My step is:
wget http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.18.tar.gz
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
cd /usr/local/src
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./bootstrap
gmake
gmake install
cd ../
tar zxvf bison-2.5.tar.gz
cd bison-2.5
./configure
make
make install
cd ../
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar xvf mysql-5.5.18.tar.gz
cd mysql-5.5.18/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data/mysql \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DSYSCONFDIR=/etc \
-DINSTALL_SHAREDIR=share
make
make install
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
cd /mysql-5.5.18/support-files
cp mysql.server /etc/init.d/mysql
cd /etc/init.d/
chmod +x mysql
chkconfig --level 3 mysql on
service mysql start
ln -fs /usr/local/mysql/bin/mysql mysql
all the step seems smoothly,
/usr/local/mysql/bin/mysql
return: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Then try:
/usr/local/mysql/bin/mysql -u admin
enter the mysql,
mysql> show databases;
This return:
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
Just 2 tables lay in mysql, missing user table.
# rpm -qa | grep -i mysql only return 2 files:
perl-DBD-MySQL-3.0007-2.el5
libmysqlclient15-5.0.77-1.1.w5
Where is the problem? how to solved? Thanks.
wget http://mysql.mirrors.pair.com/Downloads/MySQL-5.5/mysql-5.5.18.tar.gz
wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
cd /usr/local/src
tar zxvf cmake-2.8.4.tar.gz
cd cmake-2.8.4
./bootstrap
gmake
gmake install
cd ../
tar zxvf bison-2.5.tar.gz
cd bison-2.5
./configure
make
make install
cd ../
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
tar xvf mysql-5.5.18.tar.gz
cd mysql-5.5.18/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/data/mysql \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DSYSCONFDIR=/etc \
-DINSTALL_SHAREDIR=share
make
make install
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
cd /mysql-5.5.18/support-files
cp mysql.server /etc/init.d/mysql
cd /etc/init.d/
chmod +x mysql
chkconfig --level 3 mysql on
service mysql start
ln -fs /usr/local/mysql/bin/mysql mysql
all the step seems smoothly,
/usr/local/mysql/bin/mysql
return: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Then try:
/usr/local/mysql/bin/mysql -u admin
enter the mysql,
mysql> show databases;
This return:
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
Just 2 tables lay in mysql, missing user table.
# rpm -qa | grep -i mysql only return 2 files:
perl-DBD-MySQL-3.0007-2.el5
libmysqlclient15-5.0.77-1.1.w5
Where is the problem? how to solved? Thanks.