Tcp/ip connections fail

2004-05-16 Thread Randall Perry
; (Using password: YES) What else could be blocking net connections? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: User permissions error on CREATE TABLE

2004-05-16 Thread Randall Perry
D] > > But if I'm logged in as joe to the joe db and try to create a table, I get > the error: > > ERROR 1142: create command denied to user: '[EMAIL PROTECTED]' for table 'test' > > What could be wrong here? -- Randall Perry sysTame Xserve Web

User permissions error on CREATE TABLE

2004-05-16 Thread Randall Perry
mmand denied to user: '[EMAIL PROTECTED]' for table 'test' What could be wrong here? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: htt

Re: secure automated access (was "Re: Backing up all databases")

2003-11-17 Thread Randall Perry
the password. > Removing them so that the entry reads: > > [client] > password=mysql_root_password > > will correct the problem. That was it. Thanks everyone for the help. -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales htt

Re: secure automated access (was "Re: Backing up all databases")

2003-11-17 Thread Randall Perry
be surprised if something > simple like reading .my.cnf were where it showed up. > Sorry, it's 10.3. See my next post for the solution. -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL

Re: secure automated access (was "Re: Backing up all databases")

2003-11-16 Thread Randall Perry
om source or install one of > the packages? Which version mysql? Which OS? Mac OS 10.2.3. Maybe Panther has an issue with the build? /usr/local/mysql/bin/mysql -V /usr/local/mysql/bin/mysql Ver 12.21 Distrib 4.0.14, for apple-darwin6.4 (powerpc) > > Randall Perry wrote: > >&g

Re: secure automated access (was "Re: Backing up all databases")

2003-11-13 Thread Randall Perry
;s the error. > If you don't get in, try > > mysql --defaults-file=/path/to/.my.cnf > That also doesn't work. > If that works, then .my.cnf isn't in the right place. > > If mysql works interactively, but not via cron, then the problem to be > fixed lies with cr

Re: secure automated access (was "Re: Backing up all databases")

2003-11-13 Thread Randall Perry
mysql reads the .my.cnf file, this avoids the ps "sniffing" problem, > and also keeps the password out of the script. Because you make the > .my.cnf file readable only by root, other users can't see it. (If they > can see it, you've got bigger problems than just the mysql pass

Re: secure automated access (was "Re: Backing up all databases")

2003-11-12 Thread Randall Perry
e the > .my.cnf file readable only by root, other users can't see it. (If they > can see it, you've got bigger problems than just the mysql password). > > Michael -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales

Re: Backing up all databases

2003-11-12 Thread Randall Perry
l/mysql/bin/mysqldump --opt --all-databases -p > which avoids the password being visible.. > > Cormac. > > On 12-Nov-2003 Randall Perry wrote: >> Ok, I was confused about the password thing. It works now that I'm passing >> root's password in the command: >

Re: Backing up all databases

2003-11-12 Thread Randall Perry
dd the IDENTIFIED BY clause > > GRANT ALL ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'newpassword'; > > Am I missing something? > -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Backing up all databases

2003-11-11 Thread Randall Perry
Am testing this command to backup databases: /usr/local/mysql/bin/mysqldump --opt --all-databases > /usr/local/mysql/data/mysqldump Am running as root, but it only backs up databases root has access too. What's the best way to handle this -- give root full perms on all dbs? -- Randa

Re: mysqld not reading my.cnf

2003-09-14 Thread Randall Perry
ing --key_buffer=256M --max_allowed_packet=1M --table_cache=256 --sort_buffer_size=1M --read_buffer_size=1M --myisam_sort_buffer_size=64M --thread_cache=8 --query_cache_size=16M --thread_concurrency=8 --safe-show-database --safe-user-create --skip-networking --log-bin --server-id=1 -- Randall Perry sysT

mysqld not reading my.cnf

2003-09-14 Thread Randall Perry
ad no privelages to the mysql db, but the db shows up with the SHOW DATABASES command. Does mysqladmin variables show these options? If not, how can I tell what options are active? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales

mysqld not reading my.cnf

2003-09-14 Thread Randall Perry
ad no privelages to the mysql db, but the db shows up with the SHOW DATABASES command. Does mysqladmin variables show these options? If not, how can I tell what options are active? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales

mysqld not reading my.cnf

2003-09-14 Thread Randall Perry
ad no privelages to the mysql db, but the db shows up with the SHOW DATABASES command. Does mysqladmin variables show these options? If not, how can I tell what options are active? -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales

Can't start mysql on Solaris, can't find libstdc++.so.4

2002-10-04 Thread Randall Perry
Installed mysql-3.23.43-pkg on Solaris Sparc 8. Get the missing library error on everything I try. Anyone know what to do? Here's the error log entry for the command ./usr/local/bin/safe_mysqld --user=mysql & 021004 21:41:12 mysqld started ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libs