This is definately no longer the case with 7.x (I don't have 6.x to check to
see if it ever was like that)
[ole@radius2 ole]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1973 to server version: 3.23.37-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> exit
Bye
[ole@radius2 ole]$ ls -ld /var/lib/mysql
drwxr-xr-x 11 mysql mysql 4096 Jun 24 04:02 /var/lib/mysql
If you want to upgrade to a newer version of mysql, simply get the rpm from
rawhide (you'll want to compile it yourself using rpm --rebuild
mysql-blahblah.src.rpm)
ftp://ftp.valinux.com/pub/mirrors/redhat/redhat/linux/rawhide/SRPMS/SRPMS/
HTH,
Ole Gjerde
----- Original Message -----
> Alex Kramarov wrote:
> >
> > I actually ran into this myself, and you probaly have the same problem.
try
> > logging into mysql with non-root user and with default RedHat
installation
> > (that is what I am using) you will fail. mysql connectivity from the app
to
> > the database is done through unix sockets
> >
> > /var/lib/mysql/mysql.sock
> >
> > the default permissions for the /var/lib/mysql directory are for the
mysql
> > user only, and of course root can access it, but vpopmail user cannot. I
> > just gave the directory world readable permissions, this did the trick.
i am
> > wondering if there is another way to do this ? i actually didn't see
> > anything about this issue in the first 5 pages of the mailing list
archive .
