mysql 自己编译的，授权问题请教

piaoyizu

今天编译了一下mysql，在授权的时候出现这个问题，帮忙看下！~
[root@localhost bin]# /opt/mysql/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /opt/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /opt/mysql ; /opt/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /opt/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
[root@localhost bin]# ps -aux | grep mysqld
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
root     22300  0.0  0.0  3788  652 pts/1    S+   16:14   0:00 grep mysqld
[root@localhost bin]# /opt/mysql/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/opt/mysql/bin/mysqladmin -u root password 'new-password'
/opt/mysql/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /opt/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /opt/mysql ; /opt/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /opt/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

NICKY.BOY

这个,装好了啊,没有问题啊

piaoyizu

可是我启动不起来啊！~~咋启动呢？！~~

NICKY.BOY

你启动出的什么错误?
bin/mysqld_safe --user=mysql &

piaoyizu

这样就是启动成功了么？我在sir上看北南兄的文章写的不一样！~~
运行mysql_install_db命令过后，我们查看/opt/mysql就会发现，有个var的目录。这个目录，就是用来装所有数据库的位置，比如我们创建了linuxsir的数据库后，就在在/opt/mysql/var目录中有linuxsir的目录。这回应该明白了吧。

4]启动mysql服务器，可能这是最轻松的了，不过也不能高兴的太早，因为有时会出现权限方面的错误。

mysql服务器启动，应该是/opt/mysql/share/mysql目录中的 mysql.server
启动方法是：
[root@linuxsir01 mysql]# /opt/mysql/share/mysql/mysql.server start

启动过后，我们要查看mysql是否启动了，应该用下面的命令；

[root@linuxsir01 mysql]# ps -aux | grep mysqld

如果出现的仅仅是如下的一行，那mysql是没有启动成功。

root 3345 0.0 0.1 5812 648 pts/2 S 17:41 0:00 grep mysqld

让去var里查看，我这里没有var这个文件夹！~~