安装mysql报错FATAL ERROR: Could not find ./bin/my_print_defaults的解决办法

对mysql数据库初始化过程中,会有如下报错信息:

 

1

2

3

4

5

6

7

[root@localhost scripts]# ./mysql_install_db --user=mysql

FATAL ERROR: Could not find ./bin/my_print_defaults

If you compiled from source, you need to run 'make install' to

copy the software into the correct location ready for operation.

If you are using a binary release, you must either be at the top

level of the extracted archive, or pass the --basedir option

pointing to that location.

 

按照报错信息,去mysql安装目录的bin目下查找是否有_print_defaults,在第一列的第七行有发现这个文件

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

[root@localhost bin]# ls

innochecksum       mysql_client_test           mysql_setpermission

msql2mysql         mysql_client_test_embedded  mysqlshow

myisamchk          mysql_config                mysqlslap

myisam_ftdump      mysql_convert_table_format  mysqltest

myisamlog          mysqld                      mysqltest_embedded

myisampack         mysqld_multi                mysql_tzinfo_to_sql

my_print_defaults  mysqld_safe                 mysql_upgrade

mysql              mysqldump                   mysql_waitpid

mysqlaccess        mysqldumpslow               mysql_zap

mysqlaccess.conf   mysql_find_rows             perror

mysqladmin         mysql_fix_extensions        replace

mysqlbinlog        mysqlhotcopy                resolveip

mysqlbug           mysqlimport                 resolve_stack_dump

mysqlcheck         mysql_secure_installation

 

 

看来其实不是没有这个文件,不是这个问题。

认真查看报错信息,可注意到那个路径是相对路径,是以mysql的安装目录为起始。

而初始化则是进去初始化脚本目录里运行脚本,而在这个目录下不会有./bin/my_print_defaults的。

所以回到安装目录以相对路径去执行初始化脚本。

 

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

[root@localhost mysql]# ./scripts/mysql_install_db --user=mysql

Installing MySQL system tables...

OK

Filling help tables...

OK

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:

./bin/mysqladmin -u root password 'new-password'

./bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:

./bin/mysql_secure_installation

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd ./mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

[root@localhost mysql]#

 

OK!初始化成功!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值