[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: MySQL upgrade



On Wed, 2006-03-08 at 20:01 +0000, Jim Douglas wrote:
> >From: Boris Glawe <boris boris-glawe de>
> >Reply-To: For users of Fedora Core releases <fedora-list redhat com>
> >To: For users of Fedora Core releases <fedora-list redhat com>
> >Subject: Re: MySQL upgrade
> >Date: Wed, 08 Mar 2006 18:22:06 +0100
> >
> >
> >>
> >>
> >>I was following those instruction and it said..
> >>
> >>user mysql does not exist, using root
> >>
> >>Is this a security problem ?  Should I cread a mysql user and rebuild -bb?
> >>
> >>Thanks,
> >>Jim
> >>
> >>
> >no, it's no problem.
> >
> >The instructions on the specified link are very complicated.
> >
> >Simply download the MySQL...src.rpm and build it with
> >
> >rpmbuil --rebuild MSQL....src.rpm
> >
> >greets Boris
> >
> >--
> >fedora-list mailing list
> >fedora-list redhat com
> >To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
> 
> When I run,
> 
> mysql_fix_privilege_tables --password=XXXXXXX
> 
> I get this,
> 
> This script updates all the mysql privilege tables to be usable by
> MySQL 4.0 and above.
> 
> This is needed if you want to use the new GRANT functions,
> CREATE AGGREGATE FUNCTION, stored procedures, or
> more secure passwords in 4.1
> 
> You can safely ignore all 'Duplicate column' and 'Unknown column' errors
> because these just mean that your tables are already up to date.
> This script is safe to run even if your tables are already up to date!
> 
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
> 'car/lib/mysql/mysql.sock' (111)
> Got a failure from command:
> cat /usr/share/mysql/mysql_fix_privilege_tables.sql | /usr/bin/mysql 
> --no-defaults --force --user=root --host=localhost --password=mypassword 
> --database=mysql
> Please check the above output and try again.
> 
> If you get an 'Access denied' error, you should run this script again and
> give the MySQL root user password as an argument with the --password= option
> 
> 
> I tried,
> mysql_fix_privilege_tables --password=XXXXXXX
> mysql_fix_privilege_tables --password='XXXXXXX
> mysql_fix_privilege_tables --password="XXXXXXX"'
> 
> When does this socket get created?
----
the socket

/var/lib/mysql/mysql.sock is created when mysqld service is started

above you have 'car/lib/mysql/mysql.sock' which looks like a problem.

I've never used the script to which you are referring but I've never
used MySQL 5.x either so don't go by me but I always simply consider the
following...

mysql_install_db # creates the base db's

and check out /etc/my.cnf
----
# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
----
HTH

Note, old_passwords=0 is to use the new style mysql password hash
mechanism, old_passwords=1 is to maintain compatibility with MySQL v 3.x
clients

Craig


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]