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.
mysql 5.5.18 install, missing user table
-
- Posts: 4
- Joined: 2012/01/09 12:46:26
Re: mysql 5.5.18 install, missing user table
This is my first time to setup a linux server. maybe my question seems very fool...
I still not figur out where is the problem. The best solution is re-install mysql. maybe something wrong during the first time's install processing .
Thanks all to read it.
I still not figur out where is the problem. The best solution is re-install mysql. maybe something wrong during the first time's install processing .
Thanks all to read it.
mysql 5.5.18 install, missing user table
Welcome to the CentOS fora. New users should do the recommended reading as linked in my signature.
Please pay special attention to the subject of [url=https://www.centos.org/modules/newbb/viewtopic.php?topic_id=14408&forum=47]installing software[/url], where you'll notice that CentOS is a package-managed system and source installs are [b]highly discouraged[/b].
Why would you not use the MySQL (and, if needed, development) packages that come with the distro?
Please pay special attention to the subject of [url=https://www.centos.org/modules/newbb/viewtopic.php?topic_id=14408&forum=47]installing software[/url], where you'll notice that CentOS is a package-managed system and source installs are [b]highly discouraged[/b].
Why would you not use the MySQL (and, if needed, development) packages that come with the distro?