UC知道mysql权限问题
来源：百度知道 编辑：UC知道 时间：2024/06/21 11:19:28
问题
./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql
安装到了=/usr/local/mysql 下，这里没有出问题
/usr/local/mysql/bin/mysql_install_db
创建了授权表，这里出现了很多英文
[root@localhost ~]# /usr/local/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:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/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 /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You
./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql
安装到了=/usr/local/mysql 下，这里没有出问题
/usr/local/mysql/bin/mysql_install_db
创建了授权表，这里出现了很多英文
[root@localhost ~]# /usr/local/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:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/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 /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You
应该上权限问题,这个问题我遇到过多次了
iuceflow-wiki:/usr/local/mysql # ll
total 44
drwxr-xr-x 2 root root 4096 Mar 19 15:49 bin
drwxr-xr-x 3 root root 4096 Mar 19 15:48 include
drwxr-xr-x 2 root root 4096 Mar 19 15:48 info
drwxr-xr-x 3 root root 4096 Mar 19 15:48 lib
drwxr-xr-x 2 root root 4096 Mar 19 15:49 libexec
drwxr-xr-x 4 root root 4096 Mar 19 15:49 man
drwxr-xr-x 8 root root 4096 Mar 19 15:49 mysql-test
-rw------- 1 root root 164 Mar 20 09:57 nohup.out
drwxr-xr-x 3 root root 4096 Mar 19 15:48 share
drwxr-xr-x 5 root root 4096 Mar 19 15:49 sql-bench
drwx------ 5 mysql mysql 4096 Apr 28 12:02 var
iuceflow-wiki:/usr/local/mysql #
看到吗,,,,,,只要一个VAR就好了