[前][次][番号順一覧][スレッド一覧]

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]