Description:
Hi
I have just installed MySQL Cluster Server "MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586" on SLES 11 i586 running on Oracle VM VirtualBox. After that, I am advised to run mysql_secure_installation:
SUSE:/media/sf_VM-SUSE # rpm -Uhv MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586.rpm
warning: MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-Cluster-server-gp########################################### [100%]
warning: user mysql does not exist - using root
warning: group mysql does not exist - using root
insserv: warning: current start runlevel(s) (3 5) of script `vboxadd-x11' overwrites defaults (empty).
insserv: Service network is missed in the runlevels 4 to use service mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
170216 17:02:46 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
170216 17:02:46 [Note] /usr/sbin/mysqld (mysqld 5.5.54-ndb-7.2.27-cluster-gpl) starting as process 5964 ...
170216 17:02:47 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
170216 17:02:47 [Note] /usr/sbin/mysqld (mysqld 5.5.54-ndb-7.2.27-cluster-gpl) starting as process 5971 ...
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h SUSE password 'new-password'
Alternatively you can run:
/usr/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.
Please report any problems at http://bugs.mysql.com/
However, when I run /usr/bin/mysql_secure_installation, I get the error:
"can't find a 'mysql' client in path or ./bin"
I have checked and found the script is already existing under /usr/bin:
-rwxr-xr-x 1 root root 11717 Jan 5 17:40 mysqlbug
-rwxr-xr-x 1 root root 4245 Jan 5 17:40 mysql_convert_table_format
-rwxr-xr-x 1 root root 23918 Jan 5 17:40 mysqld_multi
-rwxr-xr-x 1 root root 26688 Jan 5 17:40 mysqld_safe
-rwxr-xr-x 1 root root 7402 Jan 5 17:40 mysqldumpslow
-rwxr-xr-x 1 root root 1261 Jan 5 17:40 mysql_fix_extensions
-rwxr-xr-x 1 root root 34852 Jan 5 17:40 mysqlhotcopy
-rwxr-xr-x 1 root root 14797 Jan 5 17:40 mysql_install_db
-rwxr-xr-x 1 root root 3795752 Jan 5 17:41 mysql_plugin
-rwxr-xr-x 1 root root 8198 Jan 5 17:40 mysql_secure_installation
-rwxr-xr-x 1 root root 17485 Jan 5 17:40 mysql_setpermission
-rwxr-xr-x 1 root root 6775900 Jan 5 17:41 mysqltest
-rwxr-xr-x 1 root root 3610921 Jan 5 17:40 mysql_tzinfo_to_sql
-rwxr-xr-x 1 root root 6363081 Jan 5 17:41 mysql_upgrade
-rwxr-xr-x 1 root root 3888 Jan 5 17:40 mysql_zap
I have tried to follow some available hints/tips from forum, but it doesn't help. Can anyone be familiar with SLES 11 please help me fix this issue?
Thanks in advance.
Best regards
Phuong
How to repeat:
Hi
I have just installed MySQL Cluster Server "MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586" on SLES 11 i586 running on Oracle VM VirtualBox. After that, I am advised to run mysql_secure_installation:
SUSE:/media/sf_VM-SUSE # rpm -Uhv MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586.rpm
warning: MySQL-Cluster-server-gpl-7.2.27-1.sles11.i586.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-Cluster-server-gp########################################### [100%]
warning: user mysql does not exist - using root
warning: group mysql does not exist - using root
insserv: warning: current start runlevel(s) (3 5) of script `vboxadd-x11' overwrites defaults (empty).
insserv: Service network is missed in the runlevels 4 to use service mysql
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
170216 17:02:46 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
170216 17:02:46 [Note] /usr/sbin/mysqld (mysqld 5.5.54-ndb-7.2.27-cluster-gpl) starting as process 5964 ...
170216 17:02:47 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
170216 17:02:47 [Note] /usr/sbin/mysqld (mysqld 5.5.54-ndb-7.2.27-cluster-gpl) starting as process 5971 ...
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h SUSE password 'new-password'
Alternatively you can run:
/usr/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.
Please report any problems at http://bugs.mysql.com/
However, when I run /usr/bin/mysql_secure_installation, I get the error:
"can't find a 'mysql' client in path or ./bin"
I have checked and found the script is already existing under /usr/bin:
-rwxr-xr-x 1 root root 11717 Jan 5 17:40 mysqlbug
-rwxr-xr-x 1 root root 4245 Jan 5 17:40 mysql_convert_table_format
-rwxr-xr-x 1 root root 23918 Jan 5 17:40 mysqld_multi
-rwxr-xr-x 1 root root 26688 Jan 5 17:40 mysqld_safe
-rwxr-xr-x 1 root root 7402 Jan 5 17:40 mysqldumpslow
-rwxr-xr-x 1 root root 1261 Jan 5 17:40 mysql_fix_extensions
-rwxr-xr-x 1 root root 34852 Jan 5 17:40 mysqlhotcopy
-rwxr-xr-x 1 root root 14797 Jan 5 17:40 mysql_install_db
-rwxr-xr-x 1 root root 3795752 Jan 5 17:41 mysql_plugin
-rwxr-xr-x 1 root root 8198 Jan 5 17:40 mysql_secure_installation
-rwxr-xr-x 1 root root 17485 Jan 5 17:40 mysql_setpermission
-rwxr-xr-x 1 root root 6775900 Jan 5 17:41 mysqltest
-rwxr-xr-x 1 root root 3610921 Jan 5 17:40 mysql_tzinfo_to_sql
-rwxr-xr-x 1 root root 6363081 Jan 5 17:41 mysql_upgrade
-rwxr-xr-x 1 root root 3888 Jan 5 17:40 mysql_zap
I have tried to follow some available hints/tips from forum, but it doesn't help. Can anyone be familiar with SLES 11 please help me fix this issue?
Thanks in advance.
Best regards
Phuong
