On Wed, 2006-03-08 at 20:01 +0000, Jim Douglas wrote: > >From: Boris Glawe <boris@xxxxxxxxxxxxxx> > >Reply-To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx> > >To: For users of Fedora Core releases <fedora-list@xxxxxxxxxx> > >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@xxxxxxxxxx > >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
