OK, it seems like every time I install mysql, I run smack dab into some type of access problem -- if it isn't a password hangup, it's a mysql.sock problem or (at the moment) a refusal to allow me to create databases. I've puzzled through most of it for now, but this one has me stumped.
It's giving me perror 13, which is a write permission problem. But I've checked and double checked, and the data directory is indeed writable by my mysql account: mysql> create database Text; use Text; ERROR 1006: Can't create database 'Text'. (errno: 13) mysql> Suspended mysql_att> mkdir /usr/local/mysql/data/Text mysql_att> ls Text attalus.**.err mysql I've linked the /usr/local/mysql/data file to another filesystem with a good deal more space, but that shouldn't be a problem (that's how I set it up on another one of our machines). Thoughts? And while I'm at it, can someone also tell me what the heck the /usr/local/mysql/var directory is all about? Inevitably, the reason I reinstall mysql all the time (binary dist) is because when I get back to a machine and want to do something administrative about once a quarter, it can't find things in the var directory, but I don't HAVE a var directory. (I think the source code dist creates that, but not the binary code dist.) Thanks, --Cindy -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
