; (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
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
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
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
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
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
;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
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
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
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:
>
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]
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
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
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
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
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
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
17 matches
Mail list logo