RE: Limit Which IP Address MySQL Answers On
In your my.cnf, put a bind-address directive: bind-address=xxx.xxx.xxx.xxx Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Revoke all privileges on *.* doesn't work
mysql show grants for user3; +---+ | Grants for [EMAIL PROTECTED]| +---+ | GRANT USAGE ON *.* TO 'user3'@'%' | +---+ 1 row in set (0.00 sec) what am I doing wrong? Near the bottom it says: USAGE ||Synonym for ``no privileges'' So, you succesfully removed all privileges! That's something that always bugged me... If you really want to remove a user from your interface, you'll have to do it manually in the table. But why has it been implemented this way? If I want to remove a user, I don't want him/her to have no privileges, I want him/her to be completely out of the database... Anyone knows why they chose this route? Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what is select_limit (and what is it used for)?
Hi, the default select_limit is set to 1000. What does this mean and how can it affect a server? Is there some information out there about this variable? I can't find anything except a one line description on the MySQL site... - Christian Caron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: what is select_limit (and what is it used for)?
Ok, thanks. - Christian Caron -Original Message- From: Greg Fortune [mailto:[EMAIL PROTECTED] Sent: 7 mars, 2005 13:58 To: mysql@lists.mysql.com Cc: Caron, Christian Subject: Re: what is select_limit (and what is it used for)? It only affects the client and only when the --safe-updates, --i-am-a-dummy, -U flag is used. I assume it just places an explicit limit clause of LIMIT 1000 on the end of any select statement run from the client. It's meant to keep less experienced users from running a couple of cross product joins that output millions of lines of data. Greg Fortune On Monday 07 March 2005 10:48 am, Caron, Christian wrote: Hi, the default select_limit is set to 1000. What does this mean and how can it affect a server? Is there some information out there about this variable? I can't find anything except a one line description on the MySQL site... - Christian Caron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using mysqldump to export BLOB tables
That's because there's nothing particularly remarkable about dumping BLOB values. Possibly you could have problems if they're really large. However, I take it from your message that you're trying to dump a table with BLOB columns and not having success? If so, it'd be a good idea to post a summary of what you're trying and what the results are. Excuse me, I did not clearly explained my problem. I indeed used mysqldump to backup BLOB columns and it did not returned errors, but when I restored the information I got an error about a repeated index number. When I tried to open the dump file to correct the problem, I could not do anything with it because of the binary data inside. I used vi to do so. I had to manually copy the files from the old directory to the new, and then correct the problem. That's why I asked if mysqldump was handling this type of data... So I guess my real question is: which software (on Unix) will let me open a dump of mysqldump containing BLOB data, if possible? Thanks and sorry for the misleading question. Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using mysqldump to export BLOB tables
Hi, I have been looking around (manual, google, etc.) to find out if I can use mysqldump with BLOB tables, but to no avail. Is it possible to do so, and if yes, is there any flag I need to give to mysqldump? Or can you point me to the manual page that describes that? The page http://dev.mysql.com/doc/mysql/en/mysqldump.html did not enlight me. Thanks! - Christian Caron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_config (4.0.21) returning the wrong socket location
No it's not a bug. Look up the DBI documentation and change the mysql_sock= location in your code OR in /etc/my.cnf define the mysqld.sock file to be stored in /tmp. Hmmm... It's not a bug but I have to adapt to it? There is something wrong with mysql_config not returning the right location of the socket, unless mysql_config has been designed to explicitely return the location of the socket at the configuration time (which will be the default one if none has been specified with --with-unix-socket-path). There we go: --socket The default Unix socket file, defined when configuring MySQL. So we better use --with-unix-socket-path when we don't want to use the default socket. Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_config (4.0.21) returning the wrong socket location
Hi, I installed a fresh copie of MySQL 4.0.21 on Solaris 8 (Sparc). I did put the following in the my.cnf file: == [mysqld] User=mysql Port=3306 Socket=/usr/local/mysql/mysql.sock log [client] socket=/usr/local/mysql/mysql.sock == When I start MySQL, it does create the socket in /usr/local/mysql/. When I (or PHP, or Perl) ask mysql_config about the socket, it returns /tmp/mysql.sock... nrn6# ls -l /usr/local/mysql/mysql.sock srwxrwxrwx 1 mysqlmysql 0 Oct 21 09:30 /usr/local/mysql/mysql.sock nrn6# ls -l /tmp/mysql.sock /tmp/mysql.sock: No such file or directory nrn6# /usr/local/mysql/bin/mysql_config --socket /tmp/mysql.sock Any idea? - Christian Caron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_config (4.0.21) returning the wrong socket location
When I start MySQL, it does create the socket in /usr/local/mysql/. When I (or PHP, or Perl) ask mysql_config about the socket, it returns /tmp/mysql.sock... nrn6# ls -l /usr/local/mysql/mysql.sock srwxrwxrwx 1 mysqlmysql 0 Oct 21 09:30 /usr/local/mysql/mysql.sock nrn6# ls -l /tmp/mysql.sock /tmp/mysql.sock: No such file or directory nrn6# /usr/local/mysql/bin/mysql_config --socket /tmp/mysql.sock Any idea? I reinstalled MySQL using the --with-unix-socket-path=/usr/local/mysql/mysql.sock option in the configure string and mysql_config now returns the socket path correctly (I removed the socket option from the my.cnf). I guess mysql_config should always return the real path to the socket, that is the one from the installation files or the my.cnf (that should overwrite the default one). nrn6# /usr/local/mysql/bin/mysql_config --socket /usr/local/mysql/mysql.sock Is it a bug? Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
permissions questions...
mysql show grants for nouveau@localhost; +--- + | Grants for nouveau@localhost| +--- + | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD '4be6641910d7bc1b' | +--- + 1 row in set (0.00 sec) mysql revoke usage on *.* from nouveau@localhost; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.01 sec) mysql show grants for nouveau@localhost; +--- + | Grants for nouveau@localhost| +--- + | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD '4be6641910d7bc1b' | +--- + 1 row in set (0.00 sec) Is there a way to get rid of that? Is there a way to create a user by giving access to only one database, without giving him the permission to mysqlshow --user=[thisuser] --password=[thispassword] and retrieve all database names? He should see only the name of his database...? Thanks! - Christian Caron - 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
RE: permissions questions...
Yes, but when I create a user with any other grants, it generates automatically this grant usage on *.*: mysql use Liste_MP3; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql grant select on Liste_MP3.* to usernew@localhost identified by password; Query OK, 0 rows affected (0.01 sec) mysql show grants for usernew@localhost; +--- + | Grants for usernew@localhost | +--- + | GRANT USAGE ON *.* TO 'usernew'@'localhost' IDENTIFIED BY PASSWORD '0c2993b965 2e3c06' | | GRANT SELECT ON Liste_MP3.* TO 'usernew'@'localhost' | +--- + 2 rows in set (0.00 sec) It's a new user I never entered before, and still, it generates this usage on *.*... Thanks! -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 1 août, 2002 11:32 To: [EMAIL PROTECTED] Subject: Re: permissions questions... Caron, Thursday, August 01, 2002, 5:34:16 PM, you wrote: C mysql show grants for nouveau@localhost; C +--- C + C | Grants for nouveau@localhost| C +--- C + C | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD C '4be6641910d7bc1b' | C +--- C + C 1 row in set (0.00 sec) C mysql revoke usage on *.* from nouveau@localhost; C Query OK, 0 rows affected (0.00 sec) C Is there a way to get rid of that? :-) Yes, give to user 'nouveau' any privileges except USAGE. USAGE is a synonim for 'no privileges'. C Is there a way to create a user by giving access to only one database, C without giving him the permission to mysqlshow --user=[thisuser] C --password=[thispassword] and retrieve all database names? He should see C only the name of his database...? Yes, start mysqld with --safe-show-database option. And since 4.0.2 there is a SHOW DATABASES privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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 - 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