>Description:
I'm installing a new instance of MySQL using 5.0.67 (source) and get
the following
from mysql_secure_installation:
Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
./mysql_secure_installation: !: execute permission denied
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] Y
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
... Failed!
>How-To-Repeat:
Just install the server, run mysql_install_db, start the server and run
mysql_secure_installation.
>Fix:
>Submitter-Id: ?
>Originator: Steve Holmes
>Organization:
Purdue University Computing Center
>MySQL support: none, at the moment
>Synopsis: Problem with mysql_secure_installation script in mysql-5.0.67
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-5.0.67 (Source distribution)
>Server: ./mysqladmin Ver 8.41 Distrib 5.0.67, for pc-solaris2.10 on i386
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.67-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 min 8 sec
Threads: 1 Questions: 6 Slow queries: 0 Opens: 12 Flush tables: 1 Open
tables: 6 Queries per second avg: 0.032
>C compiler: gcc (GCC) 4.2.1
>C++ compiler: gcc (GCC) 4.2.1
>Environment:
System: SunOS sun1.ics.purdue.edu 5.10 Generic_138889-02 i86pc i386 i86pc
Architecture: i86pc
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
GCC: Using built-in specs.
Target: i386-pc-solaris2.10
Configured with: /export/src/bin/gcc/gcc/configure --prefix=/opt/gcc
--with-gnu-as --with-as=/usr/sfw/bin/gas --without-gnu-ld
--with-ld=/usr/ccs/bin/ld --with-mpfr=/usr/local
--enable-languages=c,c++,fortran,objc,obj-c++
Thread model: posix
gcc version 4.2.1
Compilation info (call): CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS='-L/usr/local/lib' ASFLAGS=''
Compilation info (used): CC='gcc' CFLAGS=' -DDBUG_OFF -O3
-fno-omit-frame-pointer -DHAVE_RWLOCK_T' CXX='gcc' CXXFLAGS=' -DDBUG_OFF
-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T'
LDFLAGS='-L/usr/local/lib ' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 9 Dec 31 17:39 /lib/libc.so -> libc.so.1
-rwxr-xr-x 1 root bin 1411368 Nov 18 11:11 /lib/libc.so.1
lrwxrwxrwx 1 root root 19 Dec 31 17:38 /usr/lib/libc.so -> ../../lib/libc.so.1
lrwxrwxrwx 1 root root 19 Dec 31 17:38 /usr/lib/libc.so.1 -> ../../lib/libc.so.1
Configure command: ./configure '--prefix=/opt/mysql-5.0.67'
'--localstatedir=/var/mysql' '--with-extra-charsets=complex'
'--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler'
'--with-libwrap' '--with-embedded-server' '--enable-shared'
'--with-embedded-privilege-control' '--with-archive-storage-engine'
'--with-federated-storage-engine' '--with-openssl' 'CC=gcc' 'CFLAGS=-O3
-fno-omit-frame-pointer' 'CPPFLAGS=-I/usr/local/include' 'CXXFLAGS=-O3
-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
'CXX=gcc' 'LDFLAGS=-L/usr/local/lib'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
