Page 1 of 1

mysql 5.5.18 install, missing user table

Posted: 2012/01/09 13:05:28
by youlichika
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.

Re: mysql 5.5.18 install, missing user table

Posted: 2012/01/10 01:06:53
by youlichika
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.

mysql 5.5.18 install, missing user table

Posted: 2012/01/10 08:09:26
by r_hartman
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?