mysql:6808
From: Masashi Tsuda <Masashi Tsuda <tsuda@xxxxxxxxxx>>
Date: Wed, 08 Jan 2003 23:52:37 +0900 (JST)
Subject: [mysql 06808] mysqladmin でパスワードが設定できない
津田と申します. vine2.6にMySQLをインストールしています. MySQLをrpmからインストールしました. しかしながら,正常にインストール作業が終了したと思うのですが, MySQLのrootユーザにパスワードを設定することができません. 以下のバージョンのrpmをインストールしてみました. % sudo rpm -Uvh MySQL_3.23.53-0vl2_i386.rpm MySQL ################################################## Installing all prepared tables 030108 23:14:50 /usr/sbin/mysqld: Shutdown Complete PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h carroll 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/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! Please report any problems with the /usr/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 https://order.mysql.com Starting mysqld daemon with databases from /var/lib/mysql % sudo rpm -Uvh MySQL-client_3.23.53-0vl2_i386.rpm MySQL-client % そして,指示の通りにrootユーザにパスワードを設定しようとすると %/usr/bin/mysqladmin -u root -h localhost password *** mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' %/usr/bin/mysqladmin -u root -h carroll password **** mysqladmin: unable to change password; error: 'Access denied for user: '@carroll' to database 'mysql'' と表示され,設定できません.suでroot権限でも同じエラーが出ます. コマンドライン上で %mysql -u root -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.53 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> と始まります.しかしながら,createでデータベースを作成することが できません. mysql>create database hoge ERROR 1044: Access denied for user: '@localhost' to database 'hoge' なぜパスワードさえも設定できないかがわかりません. 一応,以下のrpmもインストールしてみましたが,変りませんでした. MySQL-Max_3.23.53-0vl2_i386.rpm MySQL-bench_3.23.53-0vl2_i386.rpm MySQL-devel_3.23.53-0vl2_i386.rpm すみませんが,宜しくお願いします. 以下に情報を明記します. % uname -a Linux carroll 2.4.18-0vl3 #4 Sat Apr 27 00:12:50 JST 2002 i686 unknown % ls -la /lib/libc* -rwxr-xr-x 1 root root 5343926 Nov 14 09:23 /lib/libc-2.2.4.so* lrwxrwxrwx 1 root root 13 Apr 21 2002 /lib/libc.so.6 -> libc-2.2.4.so* lrwxrwxrwx 1 root root 17 Apr 21 2002 /lib/libcom_err.so.2 -> libcom_err.so.2.0* -rwxr-xr-x 1 root root 7688 Sep 29 05:00 /lib/libcom_err.so.2.0* -rwxr-xr-x 1 root root 78565 Nov 14 09:23 /lib/libcrypt-2.2.4.so* lrwxrwxrwx 1 root root 17 Apr 21 2002 /lib/libcrypt.so.1 -> libcrypt-2.2.4.so* -rwxr-xr-x 1 root root 930941 Oct 28 02:09 /lib/libcrypto.so.0.9.6b* lrwxrwxrwx 1 root root 19 Apr 21 2002 /lib/libcrypto.so.2 -> libcrypto.so.0.9.6b* % ls -la /lib/libpth* -rwxr-xr-x 1 root root 458804 Nov 14 09:23 /lib/libpthread-0.9.so* lrwxrwxrwx 1 root root 17 Apr 21 2002 /lib/libpthread.so.0 -> libpthread-0.9.so* % cat /etc/ld.so.conf /usr/X11R6/lib /usr/lib /usr/lib/sane gcc --version 2.95.3 gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) % gcc -print-libgcc-file-name /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/libgcc.a % gcc -print-search-dirs install: /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/ programs: /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/:/usr/lib/gcc-lib/i386-redhat-linux/:/usr/lib/gcc/i386-redhat-linux/2.95.3/:/usr/lib/gcc/i386-redhat-linux/:/usr/i386-redhat-linux/bin/i386-redhat-linux/2.95.3/:/usr/i386-redhat-linux/bin/ libraries: /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/:/usr/lib/gcc/i386-redhat-linux/2.95.3/:/usr/i386-redhat-linux/lib/i386-redhat-linux/2.95.3/:/usr/i386-redhat-linux/lib/:/usr/lib/i386-redhat-linux/2.95.3/:/usr/lib/:/lib/i386-redhat-linux/2.95.3/:/lib/:/usr/lib/i386-redhat-linux/2.95.3/:/usr/lib/ % perl -V Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=linux, osvers=2.2.20-0vl10, archname=i386-linux uname='linux tp240 2.2.20-0vl10 #1 tue mar 12 21:04:53 jst 2002 i686 unknown ' config_args='-des -Doptimize=-O2 -m486 -fno-strength-reduce -Dcc=gcc -Dcccdlflags=-fPIC -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux -Dd_dosuid -Dd_semctl_semun -Di_db -Di_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Dotherlibdirs=/usr/local/lib/site_perl -Uuselargefiles' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=undef usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include', optimize='-O2 -m486 -fno-strength-reduce', cppflags='-fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='2.95.3 20010315 (release)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=4 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -lgdbm -ldb -ldl -lm -lc -lcrypt -lutil perllibs=-lnsl -ldl -lm -lc -lcrypt -lutil libc=/lib/libc-2.2.4.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fPIC', lddlflags='-shared -L/usr/local/lib' Characteristics of this binary (from libperl): Compile-time options: Built under linux Compiled at Apr 12 2002 15:55:41 @INC: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl /usr/local/lib/site_perl/5.6.1/i386-linux /usr/local/lib/site_perl/5.6.1 /usr/local/lib/site_perl % env | grep -i path LD_LIBRARY_PATH=/home/dazai/tsuda/adabas/lib:/home/dazai/tsuda/adabas/lib MANPATH=/usr/local/perl5/man:/opt/local/man:/opt/man:/usr/share/man:/usr/local/man:/usr/man/preformat:/usr/man:/usr/X11R6/man:/usr/X11/man:/usr/openwin/man:/usr/dt/man:/usr/local/cap/man:/usr/local/man/japanese CC_DEF_PATH=/home/dazai/tsuda/.ccdef PATH=/home/dazai/tsuda/adabas/bin:/home/dazai/tsuda/adabas/pgm:/home/dazai/tsuda/./:/home/dazai/tsuda/bin/:/usr/bin/:/usr/bin/X11/:/home/dazai/bin/:/home/local/bin/:/usr/local/bin/:/usr/local/games/:/usr/local/lib/:/usr/local/canna/:/usr/local/MaTX/bin/:/usr/etc/:/usr/lib/:/usr/games/:/bin/:/opt/local/bin/:/opt/bin/:/usr/bin/mh/:/usr/bin/mh/inc/:/usr/sbin/:/sbin/:/usr/java/j2re1.4.0_01/bin:/usr/java/j2sdk1.4.0_01/bin % env |grep -i library env | grep -i library LD_LIBRARY_PATH=/home/dazai/tsuda/adabas/lib:/home/dazai/tsuda/adabas/lib %mysqlbug SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: tsuda To: mysql@xxxxxxxxxx Subject: [50 character or so descriptive subject here (for reference)] >Description: <precise description of the problem (multiple lines)> >How-To-Repeat: <code/input/activities to reproduce the problem (multiple lines)> >Fix: <how to correct or work around the problem, if known (multiple lines)> >Submitter-Id: <submitter ID> >Originator: >Organization: <organization of PR author (multiple lines)> >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <synopsis of the problem (one line)> >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.53 (VineLinux MySQL RPM) >Server: /usr/bin//mysqladmin Ver 8.23 Distrib 3.23.53, for pc-linux-gnu on i5\ 86 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult 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 3.23.53-Max Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 7 min 43 sec Threads: 1 Questions: 9 Slow queries: 0 Opens: 6 Flush tables: 1 Open tabl\ es: 0 Queries per second avg: 0.019 >Environment: <machine, os, target, libraries (multiple lines)> System: Linux carroll 2.4.18-0vl3 #4 Sat Apr 27 00:12:50 JST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin//perl /usr/bin//make /usr/bin//gmake /usr/bin//gcc /usr/b\ in//cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 \ -felide-constructors -fno-exceptions -fno-rtti ' LDF\ LAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 21 2002 /lib/libc.so.6 -> libc-\ 2.2.4.so -rwxr-xr-x 1 root root 5343926 Nov 14 09:23 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27332668 Apr 3 2002 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 3 2002 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Apr 21 2002 /usr/lib/libc-client.a \ -> c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-stat\ ic --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --e\ nable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-sock\ et-path=/var/lib/mysql/mysql.sock --prefix=/usr --with-extra-charsets=all --exe\ c-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --l\ ocalstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --man\ dir=/usr/share/man '--with-comment=VineLinux MySQL RPM' CC=gcc 'CFLAGS= -O3' 'C\ XXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti \ ' CXX=gcc %%%%%%%%%%%%%%%%%%%%%%%%%%% 津田 雅史 <Masashi Tsuda>
-> 6808 2003-01-08 23:52 [Masashi Tsuda <tsuda] mysqladmin でパスワードが設定できない 6809 2003-01-09 00:03 ┗[TARA <tara@xxxxxxxxx] 6811 2003-01-09 08:42 ┗[Masashi Tsuda <tsuda] 6821 2003-01-09 19:01 ┗[TARA <tara@xxxxxxxxx] 6823 2003-01-09 20:03 ┗[Masashi Tsuda <tsuda] 6824 2003-01-09 20:08 ┣[TARA <tara@xxxxxxxxx] 6825 2003-01-09 20:57 ┃┗[Masashi Tsuda <tsuda] 6828 2003-01-10 01:09 ┗[TARA <tara@xxxxxxxxx] 6829 2003-01-10 07:40 ┗[Masashi Tsuda <tsuda]