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
---------------------------------------------------------------------
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
