mysql 5.5.18 install, missing user table

Issues related to software problems.

mysql 5.5.18 install, missing user table

Postby youlichika » 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 ... .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.
youlichika
 
Posts: 4
Joined: 2012/01/09 12:46:26

Re: mysql 5.5.18 install, missing user table

Postby youlichika » 2012/01/10 01:06:53

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.
youlichika
 
Posts: 4
Joined: 2012/01/09 12:46:26

mysql 5.5.18 install, missing user table

Postby r_hartman » 2012/01/10 08:09:26

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 installing software, where you'll notice that CentOS is a package-managed system and source installs are highly discouraged.

Why would you not use the MySQL (and, if needed, development) packages that come with the distro?
r_hartman
 
Posts: 701
Joined: 2009/03/23 15:08:11
Location: Netherlands


Return to CentOS 5 - Software Support

Who is online

Users browsing this forum: No registered users and 2 guests