Cindy,
Monday, April 29, 2002, 8:03:24 PM, you wrote:
I combine into one all your postings
C> OK, it seems like every time I install mysql, I run smack dab into
C> some type of access problem -- if it isn't a password hangup, it's a
C> mysql.sock problem or (at the moment) a refusal to allow me to create
C> databases. I've puzzled through most of it for now, but this one
C> has me stumped.
C> It's giving me perror 13, which is a write permission problem. But
C> I've checked and double checked, and the data directory is indeed
C> writable by my mysql account:
Cindy, error 13 occurs when your *nix user doesn't have permission on
MySQL datadir. You wrote that you had checked permissions, but I can't
see if your permissions are right. So, give me the output of following:
ls -ls <mysql_data_dir>
[skip]
C> Thoughts?
C> And while I'm at it, can someone also tell me what the heck the
C> /usr/local/mysql/var directory is all about? Inevitably, the reason I
C> reinstall mysql all the time (binary dist) is because when I get back
C> to a machine and want to do something administrative about once a
C> quarter, it can't find things in the var directory, but I don't HAVE a
C> var directory. (I think the source code dist creates that, but not
C> the binary code dist.)
I assume /usr/local/mysql/var is your datadir, isn't it?
What OS do you use?
C> Now I'm getting:
C> mysql_att> /usr/local/mysql/bin/mysqladmin -u root password '***'
C> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
C> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[skip]
C> But that's not quite the same command I used, and that's got password
C> YES. And mind you, this is what I'm doing right after the
C> mysql_install_db script and starting up the safe_mysqld for the first
C> time. So of *course* there's no password.
Cindy, You wrote that you reinstalled MySQL server. Are you sure that
there was no installed grant tables before running mysql_install_db?
C> I finally noticed that the usernames didn't match -- the safe_mysqld
C> script assumes username mysql, but I use mysql_att, etc for different
C> machines. So. I fixed that, and reran safe_mysqld. Now I get
C> can't find host.frm. Aha, I say. I know what that is. So I run
C> the scripts/mysql_install_db. That runs. OK, cool, now I set the
C> root password.
C> [11:23am] root@attalus> ./bin/mysqladmin -u root -p password '***'
C> Enter password: ***
C> ./bin/mysqladmin: connect to server at 'localhost' failed
C> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
C> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
C> OK, so the sticky bit is set on the /tmp dir, so I'm guessing this is
C> still a matter of an access problem. But I thought the script
C> took care of that.
1. Is your MySQL server running?
2. If MySQL server is running and file mysql.sock exists in the /tmp
dir, it's really a permission problem. It's not a MySQL permission problem,
it's a problems with permissions on file and dirs.
3. If MySQL server is running and file mysql.sock doesn't exist in
the /tmp dir, it means that socket file is created in another dir. You
should specify path to your socket file using --socket options or
editing my.cnf file. You can also create a symbolik link to your socket file.
C> Thanks,
C> --Cindy
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
