List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 12 2001 1:38pm
Subject:Re: more on the install problem
View as plain text  
Well, where IS the socket?

If it is not where mysqladmin is looking, then you should add to
/etc/my.cnf:

[client]
socket=/tmp/mysql.sock

Substituting the correct full path/name for the socket.

Make sure /etc/my.cnf is world readable.

Mike Millner wrote:
> 
> I've narrowed it down some. I'm not finding the answer in archives. From the
> manual I found these commands:
> 
> shell> mysqladmin version
> shell> mysqladmin variables
> shell> mysqladmin -h `hostname` version variables
> shell> mysqladmin -h `hostname` --port=3306 version
> shell> mysqladmin -h 'ip for your host' version
> shell> mysqladmin --socket=/tmp/mysql.sock version
> 
> All these work except the first two. I tried changing the permission on /tmp
> to mysql:mysql for owner and group
> 
> I don't know what else to do. Its like mysqladmin can't find the path to
> /tmp if I don't provide the full path.
> 
> Please, any hints :)
> Thanks,
> Mike
> 
> >
> > > Hello,
> > > I just installed mysql 3.23.36 on a Debian Potato system. I know your
> > going
> > > to tell me to read the manual. I have been and will continue.
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks,
> > > Mike
> > >
> > > I have (at least) two problems
> > >
> > > When I do a ps-ef | grep mysqld:
> > > root     19004 25880  0 20:04 pts/1    00:00:00 sh
> > > /usr/local/mysql/bin/safe_mysqld --user
> > > =mysql
> > > mysql    19024 19004  0 20:04 pts/1    00:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > mysql    19026 19024  0 20:04 pts/1    00:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > mysql    19027 19026  0 20:04 pts/1    00:00:00
> > > /usr/local/mysql/libexec/mysqld --basedir=
> > >
> >
> /usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr
> > > /local/mysql/v
> > > ar/mail.mikeshome.com.pid --skip-locking
> > > root     19104 25880  0 20:40 pts/1    00:00:00 grep mysqld
> > >
> > >
> > >
> > > The server appears to be running. I'm new to mysql but that looks like
> > > running.
> > >
> > > If I do a :/usr/local/mysql# /usr/bin/mysqladmin version
> > > /usr/bin/mysqladmin: connect to server at 'localhost' failed
> > > error: 'Can't connect to local MySQL server through socket
> > > '/var/run/mysqld/mysqld.sock' (
> > > 111)'
> > > Check that mysqld is running and that the socket:
> > > '/var/run/mysqld/mysqld.sock' exists!
> > >
> >
> > Two other people have had this exact same problem in the last 24hrs.
> Please
> > lookup the archive of the list to find your answer to this one.
> >
> > >
> > > If I do a : /usr/local/mysql/bin/mysqladmin -u root -p password
> > > Enter password:
> > > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> > > error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> > >
> >
> > If this is a fresh installation, root currently has no password.
> >  mysqladmin -u root will suffice.  Also there is no space between -p and
> > your password when you do finally get around to changing it.
> >
> > >
Thread
install problemMike Millner12 Apr
  • Re: install problemRolf Hopkins12 Apr
  • more on the install problemMike Millner12 Apr
  • Re: more on the install problemGerald Clark12 Apr