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.
> >
> > >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php