Mysql user kill privilege
Hiya I got a request from a client for the rights to kill his queries if something goes wrong. Long story short, he doesn't want to have to phone. I see via the MySQL documentation, that the client would need PROCESS and SUPER privileges. Im not happy with that. Would know of an alternative solution. I could reply, write better queries, but somehow I dont think the client would be to happy with that. Kind Regards Brent Clark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql user kill privilege
I got a request from a client for the rights to kill his queries if something goes wrong. Long story short, he doesn't want to have to phone. I see via the MySQL documentation, that the client would need PROCESS and SUPER privileges. Im not happy with that. Would know of an alternative solution. I could reply, write better queries, but somehow I dont think the client would be to happy with that. A user can always kill his own queries. As long as he can have 2 simultaneous connections or more, killing his own queries should be simple. http://dev.mysql.com/doc/refman/5.1/en/kill.html If you have the PROCESS privilege, you can see all threads. If you have the SUPER privilege, you can kill all threads and statements. Otherwise, you can see and kill only your own threads and statements. -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problem with MySQL user
I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to mysql -h 172.16.1.1 -uuser -p and enter the password, they get an error denying 'user'@'hostname' Why is MySQL resolving the IPs? I figured it would be quicker to fix that than it would be to look up the specific privileges for that user, add 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Problem with MySQL user
Hi John, You can turn of name resolution by adding skip-name-resolve to the [mysqld] section of your my.cnf file. Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, September 16, 2009 4:24 PM To: mysql@lists.mysql.com Subject: Problem with MySQL user I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to mysql -h 172.16.1.1 -uuser -p and enter the password, they get an error denying 'user'@'hostname' Why is MySQL resolving the IPs? I figured it would be quicker to fix that than it would be to look up the specific privileges for that user, add 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql user and authentication ???
Hello, I just installed the 6.0.6 version of the mysqld on Linux using the binary RPM. The RPM installed all the programs then it started the mysqld server. I read lots of documents about mysql user and password. But I have no idea what the users are used for, and how users are created. The Linux root user is the only user that can start and stop the server. Is this fact correct? Thanks, -Alex
RE: mysql user and authentication ???
you can use GRANT statement to create and grant privs for a mysql db so users can access specific host DB servers @'server.domain' specific DB on specific Db Servers 'custom'@'server.domain'specific tables on specific DB customer.* specific privs (Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) for those specific tables on specific DBe.g.GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON customer.* TO 'custom'@'server.domain' IDENTIFIED BY 'obscure'; http://www.devshed.com/c/a/MySQL/Managing-MySQL-User-Accounts/1/ HTH/Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Sun, 31 Aug 2008 19:38:15 -0400 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: mysql user and authentication ??? Hello, I just installed the 6.0.6 version of the mysqld on Linux using the binary RPM. The RPM installed all the programs then it started the mysqld server. I read lots of documents about mysql user and password. But I have no idea what the users are used for, and how users are created. The Linux root user is the only user that can start and stop the server. Is this fact correct? Thanks, -Alex _ Get thousands of games on your PC, your mobile phone, and the web with Windows®. http://clk.atdmt.com/MRT/go/108588800/direct/01/
Re: mysql user password funkyness
Keith, Is it possible you have a second entry for [EMAIL PROTECTED] which doesn't require a password? - michael dykman On 9/26/07, B. Keith Murphy [EMAIL PROTECTED] wrote: Everyone, So I have never seen this before. I set up a database yesterday. I added a user today in the normal manner.. ie grant usage on *.* to 'username'@'%' identified by 'password'; Here is the thing. You exit the console and try to log in with mysql -u username -ppassword and it won't let you in... BUT it log in with both mysql -u username and also mysql -u username -p (hit enter key). So the user account works without a password. executing the show grants command shows a password so this shouldn't work. Never had this problem before and kind of hard to google for mysql user login without password but has password.. show grants for 'user'@'%'; ++ | Grants for [EMAIL PROTECTED] | ++ | GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'password_hash' | ++ There are other privileges for the appropriate databases but they really aren't relevant. thanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877 -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql user password funkyness
Thanks everyone for the replies. The problem revolved around '%' vs 'localhost'. To me, it seems logical that '%' would include localhost..not really true. So, I have it figured out. thanks, Keith - Original Message - From: B. Keith Murphy [EMAIL PROTECTED] To: mysql mysql@lists.mysql.com Sent: Wednesday, September 26, 2007 10:39:17 PM (GMT-0500) America/New_York Subject: mysql user password funkyness Everyone, So I have never seen this before. I set up a database yesterday. I added a user today in the normal manner.. ie grant usage on *.* to 'username'@'%' identified by 'password'; Here is the thing. You exit the console and try to log in with mysql -u username -ppassword and it won't let you in... BUT it log in with both mysql -u username and also mysql -u username -p (hit enter key). So the user account works without a password. executing the show grants command shows a password so this shouldn't work. Never had this problem before and kind of hard to google for mysql user login without password but has password.. show grants for 'user'@'%'; ++ | Grants for [EMAIL PROTECTED] | ++ | GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'password_hash' | ++ There are other privileges for the appropriate databases but they really aren't relevant. thanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877 -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877
mysql user password funkyness
Everyone, So I have never seen this before. I set up a database yesterday. I added a user today in the normal manner.. ie grant usage on *.* to 'username'@'%' identified by 'password'; Here is the thing. You exit the console and try to log in with mysql -u username -ppassword and it won't let you in... BUT it log in with both mysql -u username and also mysql -u username -p (hit enter key). So the user account works without a password. executing the show grants command shows a password so this shouldn't work. Never had this problem before and kind of hard to google for mysql user login without password but has password.. show grants for 'user'@'%'; ++ | Grants for [EMAIL PROTECTED] | ++ | GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD 'password_hash' | ++ There are other privileges for the appropriate databases but they really aren't relevant. thanks, Keith -- B. Keith Murphy Database Administrator iContact 2635 Meridian Parkway, 2nd Floor Durham, North Carolina 27713 blog: http://blog.paragon-cs.com (o) 919-433-0786 (c) 850-637-3877
Become mysql user
I think I need to su - mysql and it askes for a password. What is that password? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Become mysql user
On Monday 21 August 2006 08:40 am, Karl Larsen wrote: I think I need to su - mysql and it askes for a password. What is that password? If you're root you don't need to enter a password. If you can't become root then the system admin has that information. Karl -- Chris White PHP Programmer/DBooker Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Become mysql user
On 8/21/06, Chris White [EMAIL PROTECTED] wrote: On Monday 21 August 2006 08:40 am, Karl Larsen wrote: I think I need to su - mysql and it askes for a password. What is that password? If you're root you don't need to enter a password. If you can't become root then the system admin has that information. Karl Or, if you are allowed to use sudo, the command to enter would be $ sudo su mysql and the password to enter would normally be your own password JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out Of Memory problems: One MySQL user, 86 minutes sleeping
Hello. 1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld 1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld These are the threads of the same mysqld process which is using only 72m of virtual memory. May be you should find out other process which is consuming memory. If you are sure that MySQL is guilty than send to the list the output of 'SHOW VARIABLES' statement. thomas Armstrong wrote: Hi. Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9), I'm suffering several memory problems ('Out Of Memory' problem) on my server. Playing around with my server: SHOW PROCESSLIST Id | User | Host | db | Command | Time | State | Info 20138 | user1 | localhost | user1_db | Sleep | 5295 | NULL (why is this user1 sleeping for 86 minutes?) SHOW STATUS: Qcache_free_blocks =0956 Qcache_free_memory =0911676280 Qcache_hits =09762140 Qcache_inserts =09109122 Qcache_lowmem_prunes =0912575 Qcache_not_cached =09897 Qcache_queries_in_cache =09644 Qcache_total_blocks =091582 - []# top - top - 12:55:40 up 1 day, 2:18, 2 users, load average: 0.39, 0.35, 0.29 Tasks: 88 total, 2 running, 86 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0% us, 0.3% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% s= i Mem:508072k total, 499980k used, 8092k free,69828k buffers Swap: 1084376k total, 2176k used, 1082200k free, 116264k cached PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 1980 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.24 mysqld 1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld 1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1985 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1986 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.21 mysqld 1987 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.13 mysqld 1988 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1989 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.06 mysqld 14337 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 17323 apache15 0 42056 30m 16m S 0.0 6.1 0:02.44 httpd 2316 ogo 16 0 36092 28m 23m S 0.0 5.7 0:01.25 ogo-webui-1.0a 11228 apache16 0 36600 24m 18m S 0.0 4.9 1:51.20 httpd 14276 apache15 0 34408 24m 16m S 0.0 4.8 0:58.17 httpd 15737 apache15 0 34120 23m 16m S 0.0 4.8 0:32.92 httpd - []# more /etc/my.conf [mysqld] datadir=3D/var/lib/mysql socket=3D/var/lib/mysql/mysql.sock query-cache-size=3D20M query-cache-type=3D1 default-character-set=3Dutf8 # Slow queries log log-slow-queries =3D /var/log/mysql/slow-queries.log long_query_time =3D 5 log-long-format [mysql.server] user=3Dmysql basedir=3D/var/lib [safe_mysqld] err-log=3D/var/log/mysqld.log pid-file=3D/var/run/mysqld/mysqld.pid --- []# free -m -- total used free sharedbuffers cached Mem: 496487 8 0 68113 -/+ buffers/cache:305190 Swap: 1058 2 1056 --- I'm trying to find out the reason of my memory problems. I suspect this sleeping user is to blame. Any suggestion? Thank you very much. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Out Of Memory problems: One MySQL user, 86 minutes sleeping
Hi. Using MySQL 4.1.9 on Linux FedoraCore2 (kernel 2.6.9), I'm suffering several memory problems ('Out Of Memory' problem) on my server. Playing around with my server: SHOW PROCESSLIST Id | User | Host | db | Command | Time | State | Info 20138 | user1 | localhost | user1_db | Sleep | 5295 | NULL (why is this user1 sleeping for 86 minutes?) SHOW STATUS: Qcache_free_blocks 56 Qcache_free_memory 11676280 Qcache_hits 762140 Qcache_inserts 109122 Qcache_lowmem_prunes12575 Qcache_not_cached 897 Qcache_queries_in_cache 644 Qcache_total_blocks 1582 - []# top - top - 12:55:40 up 1 day, 2:18, 2 users, load average: 0.39, 0.35, 0.29 Tasks: 88 total, 2 running, 86 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0% us, 0.3% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Mem:508072k total, 499980k used, 8092k free,69828k buffers Swap: 1084376k total, 2176k used, 1082200k free, 116264k cached PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 1980 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.24 mysqld 1981 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:03.53 mysqld 1982 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1983 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1984 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1985 mysql 17 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1986 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.21 mysqld 1987 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.13 mysqld 1988 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 1989 mysql 16 0 72064 42m 6172 S 0.0 8.5 0:00.06 mysqld 14337 mysql 20 0 72064 42m 6172 S 0.0 8.5 0:00.00 mysqld 17323 apache15 0 42056 30m 16m S 0.0 6.1 0:02.44 httpd 2316 ogo 16 0 36092 28m 23m S 0.0 5.7 0:01.25 ogo-webui-1.0a 11228 apache16 0 36600 24m 18m S 0.0 4.9 1:51.20 httpd 14276 apache15 0 34408 24m 16m S 0.0 4.8 0:58.17 httpd 15737 apache15 0 34120 23m 16m S 0.0 4.8 0:32.92 httpd - []# more /etc/my.conf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock query-cache-size=20M query-cache-type=1 default-character-set=utf8 # Slow queries log log-slow-queries = /var/log/mysql/slow-queries.log long_query_time = 5 log-long-format [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid --- []# free -m -- total used free sharedbuffers cached Mem: 496487 8 0 68113 -/+ buffers/cache:305190 Swap: 1058 2 1056 --- I'm trying to find out the reason of my memory problems. I suspect this sleeping user is to blame. Any suggestion? Thank you very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~/.my.cnf syntax for multiple MySQL user accounts per login account?
I've checked everywhere I can find (Paul DuBois' MySQL, ML archives, dev.mysql.com, my local User Group) for this, but everything I find either describes a simplistic or far more complex case. This is all on my local box, no networking required, and I'm the only one accessing the data. I've four MySQL related accounts: root, admin, keeling, and sbk. root is the root mysql user (which I'd prefer to leave alone once the rest is working, which it mostly is). admin is just for trivial mysqladmin stuff. keeling is a full blown admin account able to create and drop db's. sbk is a user account intended for entering/changing/querying data. So, I'd like (ie.) this ~/.my.cnf to control my login account access to the db: --- [client] user= sbk # -- user use of mysql related clients password= ... [mysql] user= keeling # -- admin use of mysql-client password= ... user= sbk # -- user use of mysql-client password= ... [mysqladmin] user= keeling password= ... [mysqladmin] user= admin password= --- Of course, it's been chmodded 600. Infuriatingly, no matter how many iterations of massaging this, when it works for sbk it's broken for keeling, and vice versa: (0) infidel /home/keeling/devl/perl/cuug_ mysql -u keeling ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way. How is this supposed to work? Surely, you're not all embedding passwords in your source, are you? How can I have separate user and admin accounts working via ~/.my.cnf from the same login account? This is MySQL 4.0 on Debian/Gnu Linux (Testing/Etch) (note the anonymous user accounts have had their passwords changed, if they exist at all; I'm not sure about that latter bit). Yes, there are more recent MySQL versions available in the repositories, but I don't need bleeding edge features. I just need base functionality. Please point me at FAQs or websites that explain this better than those I've seen so far. Thanks. Much appreciated. -- Any technology distinguishable from magic is insufficiently advanced. (*) http://www.spots.ab.ca/~keeling - - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?
I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. At 16:39 -0600 10/2/05, s. keeling wrote: I've checked everywhere I can find (Paul DuBois' MySQL, ML archives, dev.mysql.com, my local User Group) for this, but everything I find either describes a simplistic or far more complex case. This is all on my local box, no networking required, and I'm the only one accessing the data. I've four MySQL related accounts: root, admin, keeling, and sbk. root is the root mysql user (which I'd prefer to leave alone once the rest is working, which it mostly is). admin is just for trivial mysqladmin stuff. keeling is a full blown admin account able to create and drop db's. sbk is a user account intended for entering/changing/querying data. So, I'd like (ie.) this ~/.my.cnf to control my login account access to the db: --- [client] user= sbk # -- user use of mysql related clients password= ... [mysql] user= keeling # -- admin use of mysql-client password= ... user= sbk # -- user use of mysql-client password= ... [mysqladmin] user= keeling password= ... [mysqladmin] user= admin password= --- Of course, it's been chmodded 600. Infuriatingly, no matter how many iterations of massaging this, when it works for sbk it's broken for keeling, and vice versa: (0) infidel /home/keeling/devl/perl/cuug_ mysql -u keeling ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way. How is this supposed to work? Surely, you're not all embedding passwords in your source, are you? How can I have separate user and admin accounts working via ~/.my.cnf from the same login account? This is MySQL 4.0 on Debian/Gnu Linux (Testing/Etch) (note the anonymous user accounts have had their passwords changed, if they exist at all; I'm not sure about that latter bit). Yes, there are more recent MySQL versions available in the repositories, but I don't need bleeding edge features. I just need base functionality. Please point me at FAQs or websites that explain this better than those I've seen so far. Thanks. Much appreciated. -- Any technology distinguishable from magic is insufficiently advanced. (*) http://www.spots.ab.ca/~keeling - - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?
Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way. How is this supposed to work? Surely, you're not all embedding passwords in your source, are you? How can I have separate user and admin accounts working via ~/.my.cnf from the same login account? I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. Groan. More stuff to learn, configure, maintain, and memorize. I'm trying to replicate Unix's root vs. mere user security paradigm in MySQL. I can do drop table as sbk without hurting myself. Doing it as keeling risks data loss. How about if I submit a feature request? Parse the command line. If command == bar and MySQL user == foo, find foo's password stanza for bar in ~/.my.cnf, and use that password. That shouldn't be difficult. Why does a perl program run by my login username ignore MySQL's ~/.my.cnf? Are MySQL users really embedding passwords in their code? How do I use the passwordless admin account? Should that stanza just be deleted from .my.cnf? How do other db's handle this, or do they? -- Any technology distinguishable from magic is insufficiently advanced. (*) http://www.spots.ab.ca/~keeling - - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?
At 18:50 -0600 10/2/05, s. keeling wrote: Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: The admin account, with no password, doesn't function at all. perl programs appear to ignore ~/.my.cnf forcing me to open() them and slurp username and password that way. How is this supposed to work? Surely, you're not all embedding passwords in your source, are you? How can I have separate user and admin accounts working via ~/.my.cnf from the same login account? I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. Groan. More stuff to learn, configure, maintain, and memorize. I'm trying to replicate Unix's root vs. mere user security paradigm in MySQL. I can do drop table as sbk without hurting myself. Doing it as keeling risks data loss. I think your analogy is flawed. If you really want the root vs mere user distinction, the anolgy would be that you su to the appropriate user before running MySQL programs. If you did that, the .my.cnf for each user would be read correctly. How about if I submit a feature request? Parse the command line. If command == bar and MySQL user == foo, find foo's password stanza for bar in ~/.my.cnf, and use that password. That shouldn't be difficult. If you submit a feature request, I hope that it would be more detailed than that. I suspect it's not so easy as you think. Why does a perl program run by my login username ignore MySQL's ~/.my.cnf? Are MySQL users really embedding passwords in their code? Because you're not using the mysql_read_default_group or mysql_read_default_file option in your connect string, most likely. This is what I do after parsing command line arguments: # construct data source my $dsn = DBI:mysql:sampdb; $dsn .= ;host=$host_name if $host_name; $dsn .= ;port=$port_num if $port_num; $dsn .= ;mysql_socket=$socket_name if $socket_name; $dsn .= ;mysql_read_default_group=client; # connect to server my $dbh = DBI-connect ($dsn, $user_name, $password, { RaiseError = 1, PrintError = 0, AutoCommit = 1 }); -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?
Incoming from Paul DuBois: At 18:50 -0600 10/2/05, s. keeling wrote: Groan. More stuff to learn, configure, maintain, and memorize. I'm trying to replicate Unix's root vs. mere user security paradigm in I think your analogy is flawed. If you really want the root vs mere user distinction, the analogy would be that you su to the appropriate user before running MySQL programs. If you did that, the .my.cnf I am the appropriate user. It's my database, and no other user has access. The root mysql user has given my login ID two roles: administrator and user of the db. I don't want to add the complexity of multiple login accounts, nor should I have to. MySQL is an app, which I as a user should be able to use as my OS's security regime allows. How about if I submit a feature request? Parse the command line. If If you submit a feature request, I hope that it would be more detailed No need, since this: Because you're not using the mysql_read_default_group or mysql_read_default_file option in your connect string, most likely. works perfectly. Just what I was looking for for the perl programs. Thanks. Now I just need to futz with ~/.my.cnf, dependent on whether I want keeling or sbk to have passwordless access. This is workable. -- Any technology distinguishable from magic is insufficiently advanced. (*)http://www.spots.ab.ca/~keeling Please don't Cc: me. - - For the ChiComms: democracy human rights Taiwan Independence -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql user name length
Just to make things REALLY messy... try setting the default character set of a 4.1 server to utf8, and then importing your data from 4.0... your mysql usernames are in real trouble now, because utf8 considers itself to be multi byte and takes more space, cutting down on the 16 characters by.. well... let's just say it's painful. Took me some time to figure out why it wasn't accepting my new usernames - very unpleasant. Best Regards, Bruce On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote: Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may cause... Yes, there are a number of places within the server that only expect the username to be 16 characters, and will almost certainly break in the face of longer usernames. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql user name length
Hi all, Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may cause... Thanks, Tim. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql user name length
On Wed, Jul 06, 2005 at 03:46:02PM -0700, Tim Traver wrote: Is there any reason why I shouldn't increase the size of the allowable user names in mysql to var(32) instead of the default var(16) ??? Couldn't really find much on it, but wanted to ask if anyone knows of any troubles this may cause... Yes, there are a number of places within the server that only expect the username to be 16 characters, and will almost certainly break in the face of longer usernames. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where is mysql user/password list kept??
Greetings, I looking at using mysqlhotcopy to back-up my server's database. However mysqlhotcopy doesn't include backing-up the user/password file (am I wrong?). I'd like to also include a back-up of the DB access control list but I can't seem to find it... I'm also a beginner in using mysql. I've tried to googling and searching the mysql mailing list for this but I didn't have any luck finding an answer. Thanks Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Where is mysql user/password list kept??
Michael, They, passwords, stored in mysql database that comes with every install of MySQL. Mikhail Berman -Original Message- From: Michael [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 3:29 PM To: mysql@lists.mysql.com Subject: Where is mysql user/password list kept?? Greetings, I looking at using mysqlhotcopy to back-up my server's database. However mysqlhotcopy doesn't include backing-up the user/password file (am I wrong?). I'd like to also include a back-up of the DB access control list but I can't seem to find it... I'm also a beginner in using mysql. I've tried to googling and searching the mysql mailing list for this but I didn't have any luck finding an answer. Thanks Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Where is mysql user/password list kept??
At 12:29 -0700 5/20/05, Michael wrote: Greetings, I looking at using mysqlhotcopy to back-up my server's database. However mysqlhotcopy doesn't include backing-up the user/password file (am I wrong?). I'd like to also include a back-up of the DB access control list but I can't seem to find it... I'm also a beginner in using mysql. I've tried to googling and searching the mysql mailing list for this but I didn't have any luck finding an answer. This information is stored in the user table of the mysql database. http://dev.mysql.com/doc/mysql/en/privileges.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ulimit effects on mysql user?
if I have changed my /etc/security/limits.conf file to include these lines: mysqlsoft nofile4096 mysqlhard nofile63536 and then done: [EMAIL PROTECTED] root]# su mysql [EMAIL PROTECTED] root]$ ulimit -n 8192 [EMAIL PROTECTED] root]$ ulimit -n 8192 does this new 8192 open file limit apply to the already-running mysqld process, which was started like so: [EMAIL PROTECTED] root]# /usr/local/mysql/bin/mysqld_safe --user=mysql ? or will I need to restart the mysql server and/or machine to have the new open files limit take effect for the mysql server? am I correct that the open files limit placed on the mysql user will be the limit faced by the mysqld process, since the process is started with the --user=mysql option? thanks, -L
Re: ulimit effects on mysql user?
Hi Luke, all, Am Do, den 03.03.2005 schrieb Crouch, Luke H. um 15:44: if I have changed my /etc/security/limits.conf file to include these lines: mysqlsoft nofile4096 mysqlhard nofile63536 and then done: [EMAIL PROTECTED] root]# su mysql [EMAIL PROTECTED] root]$ ulimit -n 8192 [EMAIL PROTECTED] root]$ ulimit -n 8192 does this new 8192 open file limit apply to the already-running mysqld process, [[...]] the limit value is an attribute of the currently running shell whose initial value is taken from the machine's administrative settings at login time. Any change applies to the shell's current value. This is inherited by all child processes when these are forked. A later change does not affect child processes which are already running. In this respect, compare it to an environment variable. ? or will I need to restart the mysql server and/or machine to have the new open files limit take effect for the mysql server? am I correct that the open files limit placed on the mysql user will be the limit faced by the mysqld process, since the process is started with the --user=mysql option? See above. BTW: Please break your long lines. Regards, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: anonymous localhost user in mysql user grant table
rusty [EMAIL PROTECTED] wrote: What's the purpose of the entry in the user table where it has host='localhost' and user='' (blank) and all of the permissions set to N? You may want to look at http://dev.mysql.com/doc/mysql/en/Privilege_system.html and http://dev.mysql.com/doc/mysql/en/User_Account_Management.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
anonymous localhost user in mysql user grant table
What's the purpose of the entry in the user table where it has host='localhost' and user='' (blank) and all of the permissions set to N? In other words, is this some sort of security safety net and it would be dangerous to delete it? Or is it an example of setting up an anonymous locahost user and it's safe to delete it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: cannot add mysql user on debian sarge
I think he's trying to create the user mysql on the system. If so try if you can add any other user on your system. If this fails, it's a problem of your system. Try asking the question on a debian list. Maybe they can help you better. Regards O.Salzgeber -Ursprüngliche Nachricht- Von: Victor Pendleton [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 4. August 2004 15:28 An: 'Levi Campbell '; 'mysql ' Betreff: RE: cannot add mysql user on debian sarge Are you attempting to add a user in the MySQL database or the mysql user on the system? -Original Message- From: Levi Campbell To: mysql Sent: 8/4/04 8:12 AM Subject: cannot add mysql user on debian sarge On debian sarge, I'm trying to add a user for MySQL but every time I try, I get the following error /usr/bin/perl: relocation error: /usr/perl5/locale/gettext/gettext.so: unrecognized symbol: Perl_gthr_key_ptr What do I need to do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cannot add mysql user on debian sarge
On debian sarge, I'm trying to add a user for MySQL but every time I try, I get the following error /usr/bin/perl: relocation error: /usr/perl5/locale/gettext/gettext.so: unrecognized symbol: Perl_gthr_key_ptr What do I need to do?
RE: cannot add mysql user on debian sarge
Are you attempting to add a user in the MySQL database or the mysql user on the system? -Original Message- From: Levi Campbell To: mysql Sent: 8/4/04 8:12 AM Subject: cannot add mysql user on debian sarge On debian sarge, I'm trying to add a user for MySQL but every time I try, I get the following error /usr/bin/perl: relocation error: /usr/perl5/locale/gettext/gettext.so: unrecognized symbol: Perl_gthr_key_ptr What do I need to do? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL user passwords and ColdFusion MX6.1
Helpful Hint: I had a major problem not being able to register a DSN (Data Source Name) with the CF Administrator, using username and password from a MySQL 4.1.3 beta user table. After much hair-pulling, I discovered that CF cannot apparently handle the new 41-character format of the passwords. Killing these off, restarting with --old-passwords and redoing them as 16-char passwords allowed CF to register the DSNs. Hope this might help someone else who's going prematurely bald. Cheers Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how the redhat 9.0 adds the mysql user:
j.rabbit [EMAIL PROTECTED] wrote: This is how the redhat 9.0 mysql.spec file adds the mysql user: ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c MySQL Server -u = 27 mysql ' Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' = like other daemon users? Is this simply an oversite? I can't speak about Red Hat 9, but for MySQL itself there is no need to have a valid shell for the 'mysql' user. Thanks for the response. I just realized that slackware does this also, so there must be some reason for it. This link may offer some clues: http://www.unixfool.com/mysql-slack.shtml -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how the redhat 9.0 adds the mysql user:
j.rabbit [EMAIL PROTECTED] wrote: This is how the redhat 9.0 mysql.spec file adds the mysql user: ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c MySQL Server -u = 27 mysql ' Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' = like other daemon users? Is this simply an oversite? I can't speak about Red Hat 9, but for MySQL itself there is no need to have a valid shell for the 'mysql' user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how the redhat 9.0 adds the mysql user:
This is how the redhat 9.0 mysql.spec file adds the mysql user: ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c MySQL Server -u 27 mysql ' Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' like other daemon users? Is this simply an oversite? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference - Session Presentations?
Hello, Does anybody knows if User Conference' presentations were published somewhere on the web? I was told that it will be done shortly after the conference, and it is more than a week after the conference end... Thank you, Mihail Manolov ___ Solutions Architect Government Liquidation, LLC - Your Direct Source for Government Surplus 2131 K Street NW, 4th Floor Washington, DC 20037 Telephone: 1 (202) 467-6868 x 227 Fax Number: 1 (202) 467-5475 Cell Phone: 1 (202) 256-9044 [EMAIL PROTECTED] www.govliquidation.com www.liquidityservicesinc.com sql query server -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL User Conference - Session Presentations?
On Wed, Apr 28, 2004 at 02:51:50PM -0400, Mihail Manolov wrote: Does anybody knows if User Conference' presentations were published somewhere on the web? I was told that it will be done shortly after the conference, and it is more than a week after the conference end... They will be published at http://www.mysql.com/uc2004 by the end of the week. (Those that we've collected from the speakers, that is. We'll continue to publish additional ones as we receive them.) Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help us at MySQL user conference
Hi! I assume most of you know that we will have our annual MySQL User conference at April 14-15 in Orlando. During the conference we will give a lot of information about new MYSQL features that are already implemented in MySQL 4.1 and 5.0 and also about the new features we plan to implement in future MySQL versions. On the conference there will be a lot of MySQL developers around with intimate knowledge of all MySQL server code. I would like you to talk with them and tell us what features of MySQL are important to you. By knowing your needs, we will be able to better satisfy them! For example: - What features you find important and why. - What features you would like us to implement in the near / far future. - Talk with MySQL developers about the problems you have faced with MySQL - Ideas of how to we could do things better. - How to solve some specific problem you are facing with MySQL or some other database. - What you would need from MySQL to be able to move your current application to MySQL - Cool ideas / functions that you would like to see implemented. - New table handlers that you would like to implement / use. If you have a tough problem, put it on your laptop or on a CD/DVD and ask some of the MySQL developers to help you with it during the conference! If you can't come to the conference, please ensure that someone else you know comes and talks with our developers so that we can get your feedback/ideas to improve MySQL. The MySQL developers that will attend the conference, hold talks and be available for questions during the whole conference (and beer/vodka during the evenings) are: - Brian Aker, Director of Architecture (Slashdot Database Architect) UDF, Storage Engines, Apache, replication, Perl, using MySQL under high load. - Sergei Golubchik, Sr Software Engineer MyISAM, Merge Tables, Full Text Search - Lars Thalmann, Software Engineer MySQL Cluster, Replication - Mikael Ronstrom, Sr Software Architect MySQL Cluster, NDB API - Konstantin Osipov, Software Engineer Cursors, Prepared Statements - Peter Gulutzan, Software Architect SQL Standards, Stored Procedures - Alexander Byelkin, Software Engineer Sub-queries, Query Cache, Views - Mark Matthews, Software Dev Manager Connector/J, JDBC, Java - Jim Winstead, Lead Web Developer PHP, Apache, MySQL.com webmaster - Alfredo Kojima, Software Engineer MySQL Adminstrator, Windowmaker, other MySQL GUI tools - Mike Zinner, Software Engineer MySQL Adminstrator, Workbench, other MySQL GUI tools - Peter Zaitsev, Benchmarks Specialist Optimizations, Benchmarks - Alexey Holyfoot Botchkov, Software Developer Embedded Library, GIS Support - Heikki Tuuri, Innodb Author Innodb Storage Engine - David Axmark, Co-Founder MySQL Community - Carsten Pedersen, MySQL certification - Monty Widenius, Founder and CTO Main author of MySQL; Knows most things that are worth knowing about MySQL, MyODBC and some more. You can find more information on our conference including a complete list of sessions, labs, workshops and speakers at: http://www.mysql.com/uc2004 Hope to see a lot of you there! Regards, Monty CTO of MySQL AB PS: The conference is not only for developers. It's perfectly ok to bring your boss with you to get him convinced that MySQL is a safe bet:) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Community Contributor Discount for the 2004 MySQL User Conference
Greetings All, As promised a few weeks ago (but only delivered today), MySQL is offering a $100 discount on the MySQL 2004 User Conference conference fee for attendees who contribute to the Free and Open Source Software commons. The purpose of this discount is both to reward people for their work in the community and to encourage others to start contributing. To get the discount, you need to have made a significant contribution to the Free and Open Source Software (FOSS) community. Demonstrating this should be fairly simple. Some examples of how your might do this could be: - mail me links to some support entries from FOSS support lists that you contribute to - show me a software package that you have contributed to that is released under a FOSS license - show me links to CVS commit messages for FOSS-licensed software documentation - etc You don't need to be an expert or a project leader to get the discount. Just show a consistent activity and a strong commitment to helping other people in the community! If everything looks good, I will email you a code and instructions so that you can register online. If I have some questions, I will write. I know that this is not a very objective system, but it will have to do for this year's conference! :) Also, if you have already paid the conference fee, we can retroactively apply the discount if you follow the above steps. Please Note: If you have already received the early bird discount, I can't give you this discount. Still, drop me a line and I will buy you a beverage of your preference at the conference. :) Cheers! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference Computer Lab Sessions and Early Bird Sessions
Greetings All, If you are interested in attending the conference in person (or virtually), please read on. First, in addition to our regularly scheduled conference sessions, we are going to be having about a dozen training sessions. The sessions will let small groups of attendees (about 10 per session) get 30 to 90 minutes of hands-on training with MySQL staff and MySQL community leaders. We will be covering topics like query and server optimization, coaching on new (and old) feature use and providing step-by-step demos of some cool new software. Perhaps the most exciting session for the veteran hackers on this list will be a 90 minute workshop with some of our developers (including Monty) where they will walk you through the major architectural components (and the corresponding source) of the MySQL database and MyISAM storage engine. While MySQL is providing the speakers for the sessions, Apple is graciously providing the computers - students will be sharing a shiny new G5 during the training. We are currently looking at ways to let people participate virtually in some of these sessions and are going to be testing the use of VNC and other remote technologies. If you want to participate in the testing, please write me personally and let me know. These sessions will be included in the conference fees, but space is limited and attendees will have to register to participate. A fixed list of sessions and registration for them should be posted next week. The conference team will send out an informational message at that time. Speaking of conference fees, the $100 early bird discount ends on February 14th. To take advantage of the discount, visit https://order.mysql.com/?sub=pgpg_no=14 Also, as a reward for the people who help keep Free Software and Open Source going, I am happy to announce that we will be offering a discount to the conference fee to those who actively contribute to the software and community commons. I will post the guidelines for eligibility early next week. If you have any questions, feel free to drop me a line - though please note that I will be traveling for the next week and may take a day or three to respond. Finally, if the mention of the conference comes as a surprise to you, visit http://www.mysql.com/events/uc2004/ for an overview. Cheers! --zak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference 2004: Choosing the Internals/Advanced Sessions
Greetings All, My name is Zak Greant. I work for MySQL AB as their community advocate - I am also helping to organize the content for our upcoming MySQL User Conference (http://mysql.com/events/uc2004) that is happening in April. Our deadline for choosing the final list of sessions is a couple of days away. We have so much excellent content that has been proposed that we need some help from the community in choosing the content that is best for the event. Here are seven advanced/internals talks that we are considering. Please let me know which talks you would best like to see. Notes: * We will be posting addition information on the accepted sessions to http://mysql.com/events/uc2004/sessions.html within the next day. * Even if you are not going, your feedback is valuable to you as we will work to post papers from most of the accepted sessions. * We are open to suggestions for other content in the form of BoF sessions and lightning talks (see http://www.mysql.com/events/uc2004/speakers.html) The session titles are: * Connecting Data to MySQL, writing a simple Storage Engine * Hack Proofing MySQL * MySQL performance comparison on RedHat linux, Debian GNU/Linux and FreeBSD * Performance tuning for Innodb storage engine * Protecting Private Information with MySQL * Speed, Flexibility, Security: The MySQL solution to a large-store XML dilemma * The Badger Project: Improving MySQL Performance on Modern Computer Architectures Connecting Data to MySQL, writing a simple Storage Engine Noted community hacker Brian Aker demonstrates how to write your own custom storage engines for managing specialized types of data. Hack Proofing MySQL MySQL databases are a common point of attack because they typically hold the most valuable information for an organization. Because of this, locking down your MySQL databases is critical. This presentation will cover how a hacker approaches your database, the most common attacks, the most successful attacks, and how to prevent yourself from ending up as a victim. Secure your MySQL server involves properly configuring the database, educating your developers, and developing your applications to access the database securely. We will cover attacks such as SQL Injection, password brute-forcing, buffer overflow, and privilege escalation. Attendees will learn: 1) How attackers attack a MySQL server. 2) How to securely install and configure MySQL. 3) How to securely write applications for MySQL. MySQL performance comparison on RedHat linux, Debian GNU/Linux and FreeBSD When talking about databases, we normally do not think about the underlying environment on which the application is running, but this can represent a great advantage or drawback if we consider that each programmer, the application developer and the operating system developer, have to focus on his own work and depends on the work of the other.The two components have to be fine tuned to smoothly work together. When WillyStudios.com had to decide which one was the best platform to deploy its work on, we tested each environment thoroughly. In this talk we are going to present the results showed by our survey and discuss which ones are the best methods to have higher performances from the same database environment on different platforms. InnoDB Performance Tuning This session will demonstrate techniques for optimizing the performance of the InnoDB storage engine. The speaker will cover both MySQL server configuration as well as best practices for application development and OS tuning/hardware tuning. The advice provided will be supported by benchmark results. Protecting Private Information with MySQL Website managers must balance the need to provide customization with the responsibility to protect the private and sensitive information of customers. This talk will explore how some of the built-in encryption features in MySQL can create safe, strong and secure systems to guard against hackers and malicious insiders. It will begin with some simple examples and culminate with an extended example describing a website that offers all of the features of a highly-customized website like Amazon.com without keeping any personal information around. It will be the equivalent of having your cake and eating it too. Speed, Flexibility, Security: The MySQL solution to a large-store XML dilemma While MySQL databases have been used for years by the LANL Digital Library Development Team, it has been in the creation of our most ambitious project that we have truly recognized some of the unique strengths and features of MySQL. The project -- development of a comprehensive database of scientific journal articles and citation information -- involves converting bibliographic metadata from 8 distinct data suppliers into a common XML format, enhancing the data with links between each of the 50 million articles and their 507 million individual
MySQL User Conference 2004: Choosing the General Sessions
Greetings All, My name is Zak Greant. I work for MySQL AB as their community advocate - I am also helping to organize the content for our upcoming MySQL User Conference (http://mysql.com/events/uc2004) that is happening in April. Our deadline for choosing the final list of sessions is a couple of days away. We have so much excellent content that has been proposed that we need some help from the community in choosing the content that is best for the event. Here are five general talks that we are still pondering. Please let me know which talks you would best like to see. Notes: * We will be posting addition information on the accepted sessions to http://mysql.com/events/uc2004/sessions.html within the next day. * Even if you are not going, your feedback is valuable to you as we will work to post papers from most of the accepted sessions. * We are also examining ways to let people who cannot attend still experience a few of the hands-on technical sessions via technology like VNC, live audio streams and/or IRC * We are open to suggestions for other content in the form of BoF sessions and lightning talks (see http://www.mysql.com/events/uc2004/speakers.html) The session titles are: * Best Practices for MySQL Administration in an Enterprise Environment * Large Volume Data Transformation and Warehousing using MySQL * MySQL as an Embedded Database: An Implementation Story * Web Development with Bells and Whistles using MySQL * Show Me the Money: Getting Your MySQL Certification Best Practices for MySQL Administration in an Enterprise Environment Best practices to effectively manage MySQL servers in the non-web space. Best practices are bunches of norms that generally make systems safer and cheaper. We will briefly review system configuration guidelines and what best practices means. The core presentation will review practices for space and perforamnce management, object management and UDFs, security, replication, backup, recovery and disaster recovery. The talk should be useful for both new and veteran MySQL DBAs, and will focus on MySQL 4.1. Large Volume Data Transformation and Warehousing using MySQL In this session we describe a set of transformations and their corresponding layers for loading data into a data warehouse. Standard SQL is used in all steps and queries are performed on whole sets of data. The features include historisation of data, placeholders for orphaned records, type checking, consistency control, duplicate count, model transformation and optimizations. After extracting data from an operational system you are often left with relational, but not necessarily consistent data stored as text files with some kind of structure. However, for the purpose of doing analysis we need high data quality and performance, which is achieved through an efficient and consistent data model. The tables within it are our goal. In between the data is transformed and refined in several stages. In the process the data passes through different layers of transformation, where each layer is represented with its own namespace using MySQL databases. To begin with there is a temporary layer containing tables that have a one to one correspondence with the files. These are character based to ensure that no data is lost when reading the files into the database. Internal consistency and duplicate analysis is done here according to an XML definition of the model. The next layer is the raw layer, which is similar in model to the temporary layer with the exception of being persistent and having types. For data that should be historised only those records in the temporary layer that are new or constitute changes to data in raw are moved. Type, model and range errors are flagged here and another duplicate check is performed with respect to all data. Within raw we should have a complete history of all data contained in the files with some extra metadata. The model is the same as the one implied by the data in the files. Having come this far could sometimes be enough, but since this model could be denormalized we take the process one step further and provide a mechanism for converting the data into a new model. This is also useful for substituting compound natural keys with simple surrogate ones and thereby increases performance. In order to do so a key lookup layer is introduced, containing the natural keys from the raw layer together with auto incremented surrogate keys. This layer is further used to produce surrogate keys from foreign keys in orphaned records, which ensures consistency. The model in the key layer is the same as in our warehouse layer, which is loaded using a combination of data in the raw layer with the surrogate keys. The warehouse is in our case normalized according to 3NF, yielding efficient storage since data is not duplicated in the tables. However, when doing analysis we could utilize far better models when it comes
mysql user management with ldap
Hi, is it possible to manage the users present in mysql with an ldap directory ? if yes, where can I find some documentation (I didn't find it on google) ? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL user in Indonesia
I am working to port our database to mysql now. I work in PT. ADETEX. Sorry for my english. Regards, Hendro -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 1:25 PM To: [EMAIL PROTECTED] Subject: MySQL user in Indonesia Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL user in Indonesia
hendro, We are (Sumitomo Wareghouse Indonesia) using mysql from version 3.5 - untill 5.0 (gamma version). As long as my experience there's no problem using these free cost database. Right now, we still believe mysql as our primary database engine for service our site office at Karawang, Tg-Priok, and Cengkareng. Start on next year, still using this DB , we move a head for services our branch office at Surabaya (Client-Server), and middle of the year we will connect to our sister company at Sumitomo Warehouse Singapore (SIN), and Sumitomo Warehouse Malaysia (MYS), where they using different DB engine (SQL) but we have test the connector for that. Just tell your boss to do it, if she/he not agree then let's spen your company money at least $ 12.000 for basic DB only. I Hope it's help. Thanks Rie - Original Message - From: Hendro S [EMAIL PROTECTED] To: 'Leo' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 4:17 PM Subject: RE: MySQL user in Indonesia I am working to port our database to mysql now. I work in PT. ADETEX. Sorry for my english. Regards, Hendro -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 1:25 PM To: [EMAIL PROTECTED] Subject: MySQL user in Indonesia Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL user in Indonesia
Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com
Re: MySQL user in Indonesia
My company use it :) PT. Tempo Inti Media Tbk For experience sharing, contact me in private. I believe there're alot of company here using MySQL. Just take a look around. Me fail English? That's unpossible ###___Archon___### - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 1:24 PM Subject: MySQL user in Indonesia Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i have a lot of it, but he demand some example, which company in indonesia had successfully implemented mysql in their core bussiness so please, let me know.. i already run a search at google, but i have trouble determining what kwyword should i use if there is among you that work in a company here in indonesia, please, would you kindly share your experience thanks in advance -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Experiment with MySQL User Defined Functions in Java
Eric, please can you indicate how to write use an UDF in php? Thanks eric wrote: If you have a need for User Defined Functions in MySQL, now you can write them in java. (As well as C++, perl, python, or php, of course.) If you think java UDFs might be handy, please try it out and send some feed back my way. Please keep in mind that this is alpha code, so you probably don't want to test on your production data. http://freshmeat.net/projects/judf/?topic_id=66 Cheers, -- Eric Herman Seatle, WA [EMAIL PROTECTED] -- Marcelo Anelli C. Http://www.marceloanelli.com/ [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Experiment with MySQL User Defined Functions in Java
On Sat, 2003-12-20 at 06:32, Marcelo Anelli wrote: Eric, please can you indicate how to write use an UDF in php? David Sklar wrote it, I have not used it. http://www.sklar.com/page/section/projects Cheers, -- eric Thanks eric wrote: If you have a need for User Defined Functions in MySQL, now you can write them in java. (As well as C++, perl, python, or php, of course.) If you think java UDFs might be handy, please try it out and send some feed back my way. Please keep in mind that this is alpha code, so you probably don't want to test on your production data. http://freshmeat.net/projects/judf/?topic_id=66 Cheers, -- Eric Herman Seatle, WA [EMAIL PROTECTED] -- Marcelo Anelli C. Http://www.marceloanelli.com/ [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Experiment with MySQL User Defined Functions in Java
If you have a need for User Defined Functions in MySQL, now you can write them in java. (As well as C++, perl, python, or php, of course.) If you think java UDFs might be handy, please try it out and send some feed back my way. Please keep in mind that this is alpha code, so you probably don't want to test on your production data. http://freshmeat.net/projects/judf/?topic_id=66 Cheers, -- Eric Herman Seatle, WA [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to create mysql user?
dear buddy, when u specify permissions on a particular database, you need to give that database name to connect to db. user created fine, while connecting, try this: mysql -u abc -p abc where last abc is ur database name. Nitin - Original Message - From: ads mysql [EMAIL PROTECTED] To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 11:51 AM Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin [EMAIL PROTECTED] wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to create mysql user?
O K. I have tried following as advised. # [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ## Then once again I accessed mysql as root user and Granted permission as follows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 69 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON abc.* TO [EMAIL PROTECTED] IDENTIFIED BY 'abc'; Query OK, 0 rows affected (0.01 sec) mysql USE abc Database changed mysql exit Bye [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Don't know what is wrong. Thanks for support. Nitin [EMAIL PROTECTED] wrote: dear buddy, when u specify permissions on a particular database, you need to give that database name to connect to db. user created fine, while connecting, try this: mysql -u abc -p abc where last abc is ur database name. Nitin - Original Message - From: ads mysql To: Nitin ; Sent: Tuesday, December 16, 2003 11:51 AM Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: How to create mysql user?
did u do a flush privilege - Original Message - From: ads mysql [EMAIL PROTECTED] To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:00 PM Subject: Re: How to create mysql user? O K. I have tried following as advised. # [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ## Then once again I accessed mysql as root user and Granted permission as follows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 69 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON abc.* TO [EMAIL PROTECTED] IDENTIFIED BY 'abc'; Query OK, 0 rows affected (0.01 sec) mysql USE abc Database changed mysql exit Bye [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Don't know what is wrong. Thanks for support. Nitin [EMAIL PROTECTED] wrote: dear buddy, when u specify permissions on a particular database, you need to give that database name to connect to db. user created fine, while connecting, try this: mysql -u abc -p abc where last abc is ur database name. Nitin - Original Message - From: ads mysql To: Nitin ; Sent: Tuesday, December 16, 2003 11:51 AM Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to create mysql user?
As advised I tried following : ### [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 71 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) mysql exit Bye [EMAIL PROTECTED] root]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) No luck. Help appreciated. Duke, Brian [EMAIL PROTECTED] wrote: try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) -Original Message- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:21 PM To: Nitin; [EMAIL PROTECTED] Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Fw: How to create mysql user?
- Original Message - From: Nitin [EMAIL PROTECTED] To: ads mysql [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:01 PM Subject: Re: How to create mysql user? did u do a flush privilege - Original Message - From: ads mysql [EMAIL PROTECTED] To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:00 PM Subject: Re: How to create mysql user? O K. I have tried following as advised. # [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ## Then once again I accessed mysql as root user and Granted permission as follows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 69 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON abc.* TO [EMAIL PROTECTED] IDENTIFIED BY 'abc'; Query OK, 0 rows affected (0.01 sec) mysql USE abc Database changed mysql exit Bye [EMAIL PROTECTED] mysql]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Don't know what is wrong. Thanks for support. Nitin [EMAIL PROTECTED] wrote: dear buddy, when u specify permissions on a particular database, you need to give that database name to connect to db. user created fine, while connecting, try this: mysql -u abc -p abc where last abc is ur database name. Nitin - Original Message - From: ads mysql To: Nitin ; Sent: Tuesday, December 16, 2003 11:51 AM Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED
RE: How to create mysql user?
Yes, It worked with folllowing : I have created new user 'abc1' with password 'abc1' for database 'abc'. ### ## [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 83 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql USE mysql Database changed mysql INSERT INTO user (Host,User,Password) VALUES('localhost','abc1',PASSWORD('abc1')); Query OK, 1 row affected (0.00 sec) mysqlCREATE DATABASE abc; mysql INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv, Create_priv,Drop_priv) VALUES ('localhost','abc','abc1','Y','Y','Y','Y','Y','Y'); Query OK, 1 row affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql exit Bye [EMAIL PROTECTED] mysql]# mysql -u abc1 -p abc Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 84 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql ## Thanks for great support. ads mysql [EMAIL PROTECTED] wrote: As advised I tried following : ### [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 71 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) mysql exit Bye [EMAIL PROTECTED] root]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) No luck. Help appreciated. Duke, Brian wrote: try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) -Original Message- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:21 PM To: Nitin; [EMAIL PROTECTED] Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier
Re: How to create mysql user?
try restarting mysql service .. Cheers Binay - Original Message - From: ads mysql [EMAIL PROTECTED] To: Duke, Brian [EMAIL PROTECTED]; Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 2:07 PM Subject: RE: How to create mysql user? As advised I tried following : ### [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 71 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) mysql exit Bye [EMAIL PROTECTED] root]# mysql -u abc -p abc Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) No luck. Help appreciated. Duke, Brian [EMAIL PROTECTED] wrote: try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) -Original Message- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:21 PM To: Nitin; [EMAIL PROTECTED] Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to create mysql user?
Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Re: How to create mysql user?
right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant privs on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to create mysql user?
O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin [EMAIL PROTECTED] wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
RE: How to create mysql user?
try this: grant ALL on abc.* to 'abc'@'localhost' identified by 'abc'; I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) -Original Message- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 11:21 PM To: Nitin; [EMAIL PROTECTED] Subject: Re: How to create mysql user? O K. I accessed to mysql as root user and tried to created user 'abc' as folows : [EMAIL PROTECTED] mysql]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 61 to server version: 4.0.16-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. I have created database 'abc' . mysql grant ALL on abc.table to 'abc' identified by 'abc'; Query OK, 0 rows affected (0.00 sec) I want to give all permission to user abc to handle database 'abc'. Then I tried to connect as user 'abc' to mysql as follows : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Some problem. Help appreciated. Nitin [EMAIL PROTECTED] wrote: right now, u r trying to connect t omyql with uer abc, not creating it. to create user abc grant on dbname.tablename to 'abc' identified by 'abc'; you can view the list of privileges available on myql website at http://www.mysql.com/doc/en/GRANT.html Enjoy Nitin - Original Message - From: ads mysql To: Sent: Tuesday, December 16, 2003 11:09 AM Subject: How to create mysql user? Hi, I have installed mysql. As per documentation with user as 'root'. I can create Database, table. I can enter data into table. I have created user 'abc' with passowrd 'abc' on my Linux 8.0 server. by using command : adduser abc -p 'abc' Now I want to create mysql database user 'abc' with command : [EMAIL PROTECTED] mysql]# mysql -u abc -p Enter password: (entered abc) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is it granting permission to abc. I refered documentation but could not get it clearly Neet sample code. Then I connected mysql as 'root' user. and tried. mysql mysql -u abc -p; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresonds to your MySQL server version for the right syntax to use near 'mysql -u ab -p' at line 1. Syntax I got from Documentation for GRANT as follows: ### 4.4.1 GRANT and REVOKE Syntax GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...] ### Please guide me how to create users for mysql with password. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL User Conference 2004 Call for Papers
MySQL AB is please to announce that the Call for Papers for the 2004 MySQL User Conference is now officially open. We encourage every MySQL user with something to say - from grey-bearded hackers and peach-fuzzed power users to corporate code wranglers and veteran DBAs - to drop by http://mysql.com/events/uc2004/speakers.html and write up your proposals for great sessions. We are looking for sessions that speak to your peers: practical, pragmatic and clueful presentations that focus on how you solved problems in a demanding or unique technical environment. Session that introduce a particular feature set or provide hands-on training to introduce newer developers to cutting edge functionality are also welcome (as is any cool or unique presentation). You can give sessions that range in length from 5 minute lighting talks up to 90 minute power tutorials. We also have set aside slots for 30 minute technical briefs and standard hour long sessions. Additionally we are looking for solid ideas from the community for Bird-of-a-Feather (BoF) sessions. These sessions give conference attendees a chance to meet and discuss topics of common interest with their peers. Visit http://mysql.com/events/uc2004/speakers.html to suggest ideas for the BoFs that you would like to participate in. The call for papers closes on January 14th. The conference will take place on April 14th to 16th in Orlando, Florida, USA. The call for BoFs and lightning talks closes on February 14th. For additional inspiration, check out last year's schedule: http://mysql.com/events/uc2003/schedule.html If you want to briefly discuss your ideas, fill out the appropriate form at http://mysql.com/events/uc2004/speakers.html and make a note in your comment. I will write you back in a day or so with some extra input. Good Luck! See you in Orlando! -- Zak Greant MySQL AB Community Advocate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql user
SELECT user FROM mysql.user; - Original Message - From: Binay [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Sent: Friday, December 05, 2003 3:25 PM Subject: Mysql user Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql user
Greetings every body I'm developing a web application using JSP ,Mysql and jrun application server.i need the code of user authentication in jsp.Can any one supply the same Your help would be appreciated Regards Aby Technical Services Abhinav Chaturvedi TransAction Solutions Pty Ltd PO Box 6764 Silverwater NSW 1811 Ph (02) 9647-4624 Mob +61(0) 422-149-614 Fax (02) 9647- 4660 email[EMAIL PROTECTED] Warning! This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain protected material. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. If you have received this email in error, please telephone the sender on (02) 9647 4624 TransAction Solutions employs third party virus checking software.TransAction Solutions will not be held responsible for the inability of a third party software packages to detect or prevent the propagation of any virus how ever so generated -Original Message- From: Binay [mailto:[EMAIL PROTECTED] Sent: Friday, 5 December 2003 6:25 PM To: mysql users Subject: Mysql user Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql user
Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay
Mysql user
Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay
Mysql user
Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay
RE: Mysql user
Hi Binay, Use the mysql client to open the mysql database. For example, enter the following at the mysql prompt: use mysql Then type: select * from user; Bob -Original Message- From: Binay [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:26 AM To: mysql users Subject: Mysql user Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql user
Binay wrote: Hi all, Can any one tell me the command to list all mysql users ??? Thanks in advance Binay use mysql; select User from user; Ivan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql user
i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as long long but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values. i searched the manual but got no solution. - Download Yahoo! Messenger now for a chance to WIN Robbie Williams Live At Knebworth DVD
How can I become an Expert MySql User?
HiY'll I've been using MYSQL for a couple of years now. And can write some pretty complex WHERE statements. I've become aware that's really only tip of the iceberg stuff. Can readers suggest a gentle path to moving onto JOINS and a more fundamental understanding of DBs No rude answers please g zzapper -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I become an Expert MySql User?
At 06:29 AM 11/7/2003, you wrote: HiY'll I've been using MYSQL for a couple of years now. And can write some pretty complex WHERE statements. I've become aware that's really only tip of the iceberg stuff. Can readers suggest a gentle path to moving onto JOINS and a more fundamental understanding of DBs No rude answers please g zzapper -- Zzapper, Buy, beg, borrow, or steal Paul Dubois books MySql 2nd Edition and MySQL Cookbook. You will learn a lot from them. Plus I'd recommend reading the MySQL manual from cover to cover, and try your own examples in each section. Mike In another thread I had posted these SQL related links: Try one of these MySQL tutorials: http://www.mysql.com/doc/en/Tutorial.html http://www.analysisandsolutions.com/code/mybasic.htm http://www.devshed.com/Server_Side/MySQL http://www.sqlcourse.com/ http://www.w3schools.com/sql/default.asp http://www.juicystudio.com/tutorial/mysql/ http://www.justphukit.com/mysql/mysql-tutorials-1.php http://sqlzoo.net/ http://www.troobloo.com/tech/mysql.shtml http://perl.about.com/cs/mysql/index.htm http://www.anu.edu.au/web/authors/mysql/manual_Tutorial.html Reference: http://www.mysql.com/doc/en/ (the MySQL manual is quite good too) http://tiger.la.asu.edu/Quick_Ref/MySQL_QuickRef.pdf (MySQL Quick Reference Card) Related links http://dmoz.org/Computers/Software/Databases/MySQL/Tutorials/ Books: MySQL 2nd Edition by Paul Dubois MySQL Cookbook by Paul Dubois -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do I restrict a mysql user only can work on a database
Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I restrict a mysql user only can work on a database
I'll bet the real problem is that you're not being authenticated as testuser. After you try connecting to the server as testuser, issue this query: SELECT CURRENT_USER(); What's the result? At 11:57 AM +1100 10/27/03, Clive Luk wrote: Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
Please reply to the list, not to me personally, so that others can follow this discussion. At 12:13 PM +1100 10/27/03, Clive Luk wrote: it says the following.. mysql select current_user(); +---+ | current_user()| +---+ | [EMAIL PROTECTED] | +---+ 1 row in set (0.00 sec) Cheers, Clive Okay, that's correct. Let's see... ha, I didn't read your original message closely enough. Your first grant statement should says ON testdb.* rather than ON testdb. The latter syntax grants privileges to the testdb table in the current database, which isn't what you want. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:10 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: How do I restrict a mysql user only can work on a database I'll bet the real problem is that you're not being authenticated as testuser. After you try connecting to the server as testuser, issue this query: SELECT CURRENT_USER(); What's the result? At 11:57 AM +1100 10/27/03, Clive Luk wrote: Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
Thanks Paul, but how do i reset all the previous setting before I try to run the command again? Or do I need to reset the privileges? Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database Please reply to the list, not to me personally, so that others can follow this discussion. At 12:13 PM +1100 10/27/03, Clive Luk wrote: it says the following.. mysql select current_user(); +---+ | current_user()| +---+ | [EMAIL PROTECTED] | +---+ 1 row in set (0.00 sec) Cheers, Clive Okay, that's correct. Let's see... ha, I didn't read your original message closely enough. Your first grant statement should says ON testdb.* rather than ON testdb. The latter syntax grants privileges to the testdb table in the current database, which isn't what you want. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:10 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: How do I restrict a mysql user only can work on a database I'll bet the real problem is that you're not being authenticated as testuser. After you try connecting to the server as testuser, issue this query: SELECT CURRENT_USER(); What's the result? At 11:57 AM +1100 10/27/03, Clive Luk wrote: Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
At 12:26 PM +1100 10/27/03, Clive Luk wrote: Thanks Paul, but how do i reset all the previous setting before I try to run the command again? Or do I need to reset the privileges? Try: REVOKE ALL PRIVILEGES ON testdb FROM [EMAIL PROTECTED]; Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database Please reply to the list, not to me personally, so that others can follow this discussion. At 12:13 PM +1100 10/27/03, Clive Luk wrote: it says the following.. mysql select current_user(); +---+ | current_user()| +---+ | [EMAIL PROTECTED] | +---+ 1 row in set (0.00 sec) Cheers, Clive Okay, that's correct. Let's see... ha, I didn't read your original message closely enough. Your first grant statement should says ON testdb.* rather than ON testdb. The latter syntax grants privileges to the testdb table in the current database, which isn't what you want. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:10 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: How do I restrict a mysql user only can work on a database I'll bet the real problem is that you're not being authenticated as testuser. After you try connecting to the server as testuser, issue this query: SELECT CURRENT_USER(); What's the result? At 11:57 AM +1100 10/27/03, Clive Luk wrote: Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
Hi paul, Thanks for the quick reply. I have revoke all the privileges and ran grant all privileges on testdb.* to [EMAIL PROTECTED]; and i login as testuser and i have confirm with select Current_user(); that i am a testuser; and i can still select on mysql.user. just an info. select * from mysql.user where user='testuser'; | localhost | testuser | x | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N| N| N | N| || | | 0 | 0 | 0 | any clue? Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:30 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 12:26 PM +1100 10/27/03, Clive Luk wrote: Thanks Paul, but how do i reset all the previous setting before I try to run the command again? Or do I need to reset the privileges? Try: REVOKE ALL PRIVILEGES ON testdb FROM [EMAIL PROTECTED]; Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database Please reply to the list, not to me personally, so that others can follow this discussion. At 12:13 PM +1100 10/27/03, Clive Luk wrote: it says the following.. mysql select current_user(); +---+ | current_user()| +---+ | [EMAIL PROTECTED] | +---+ 1 row in set (0.00 sec) Cheers, Clive Okay, that's correct. Let's see... ha, I didn't read your original message closely enough. Your first grant statement should says ON testdb.* rather than ON testdb. The latter syntax grants privileges to the testdb table in the current database, which isn't what you want. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:10 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: How do I restrict a mysql user only can work on a database I'll bet the real problem is that you're not being authenticated as testuser. After you try connecting to the server as testuser, issue this query: SELECT CURRENT_USER(); What's the result? At 11:57 AM +1100 10/27/03, Clive Luk wrote: Hi all, I have a question. I have created ===mysql_command start== mysql GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED] - identified by 'some_passwd'; ===mysql_command end== the user can login no problem. but can see testdb ===mysql_command start== mysql show databases; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.11 sec) mysql use test; Database changed mysql show tables; Empty set (0.00 sec) mysql use mysql; Database changed mysql show tables; Empty set (0.00 sec) mysql use testdb ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql use openwebmail; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'testdb' mysql quit ===mysql_command end== and then i did that with a root login ===mysql_command start== mysql use testdb; 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,update on *.* to [EMAIL PROTECTED]; Query OK, 0 rows affected (0.00 sec) ===mysql_command end== But the testuser can actually view all databases. That's not what I really want. I just want testuser can select and update testdb. But not others. How can I restrict testuser only work on testdb? Thanks. Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/27/03, Clive Luk wrote: Hi paul, Thanks for the quick reply. I have revoke all the privileges and ran grant all privileges on testdb.* to [EMAIL PROTECTED]; and i login as testuser and i have confirm with select Current_user(); that i am a testuser; and i can still select on mysql.user. just an info. select * from mysql.user where user='testuser'; | localhost | testuser | x | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N| N| N | N| || | | 0 | 0 | 0 | any clue? What does SELECT * FROM mysql.db WHERE User='testuser' show? Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
| localhost | testdb | testuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y| the N is Grant_priv I don't understand why? thanks... Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 12:48 PM +1100 10/27/03, Clive Luk wrote: Hi paul, Thanks for the quick reply. I have revoke all the privileges and ran grant all privileges on testdb.* to [EMAIL PROTECTED]; and i login as testuser and i have confirm with select Current_user(); that i am a testuser; and i can still select on mysql.user. just an info. select * from mysql.user where user='testuser'; | localhost | testuser | x | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N| N| N | N| || | | 0 | 0 | 0 | any clue? What does SELECT * FROM mysql.db WHERE User='testuser' show? Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
At 1:06 PM +1100 10/27/03, Clive Luk wrote: | localhost | testdb | testuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y| the N is Grant_priv I don't understand why? thanks... Don't understand what? Why Grant_priv is N? It's not included in ALL PRIVILEGES. As far as being able to access the mysql database, apparently you've granted global access to it, or any-user access to it at the database level. Does SELECT * FROM mysql.db WHERE Db='mysql' show anything? Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 12:48 PM +1100 10/27/03, Clive Luk wrote: Hi paul, Thanks for the quick reply. I have revoke all the privileges and ran grant all privileges on testdb.* to [EMAIL PROTECTED]; and i login as testuser and i have confirm with select Current_user(); that i am a testuser; and i can still select on mysql.user. just an info. select * from mysql.user where user='testuser'; | localhost | testuser | x | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N| N| N | N| || | | 0 | 0 | 0 | any clue? What does SELECT * FROM mysql.db WHERE User='testuser' show? Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How do I restrict a mysql user only can work on a database
Hi Paul, FLUSH PRIVILEGES; - missing hahaha That's the command I didn't use after the commands you asked me to put in before... it is working know... I can't see mysql. I can see testdb and test... thank you very much for your help Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:15 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 1:06 PM +1100 10/27/03, Clive Luk wrote: | localhost | testdb | testuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y| the N is Grant_priv I don't understand why? thanks... Don't understand what? Why Grant_priv is N? It's not included in ALL PRIVILEGES. As far as being able to access the mysql database, apparently you've granted global access to it, or any-user access to it at the database level. Does SELECT * FROM mysql.db WHERE Db='mysql' show anything? Cheers, Clive -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 1:04 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How do I restrict a mysql user only can work on a database At 12:48 PM +1100 10/27/03, Clive Luk wrote: Hi paul, Thanks for the quick reply. I have revoke all the privileges and ran grant all privileges on testdb.* to [EMAIL PROTECTED]; and i login as testuser and i have confirm with select Current_user(); that i am a testuser; and i can still select on mysql.user. just an info. select * from mysql.user where user='testuser'; | localhost | testuser | x | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N| N| N | N| || | | 0 | 0 | 0 | any clue? What does SELECT * FROM mysql.db WHERE User='testuser' show? Cheers, Clive -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL user privileges
H?kon Nilsen \(Exinet AS\) [EMAIL PROTECTED] wrote: I *had* the anonymous user, but I deleted it since I couldn't find the use for it. But I figured out what the problem was. I was using --safe-show-database, but it didn't seem to work. My error was that I gave users privileges. I also gave the privileges to the user on the database. So I removed the privileges on the user (select, insert, delete, insert), and then it worked. If user has any privileges on the database, he can see that database in the output of SHOW DATABASES. So, now the users don't have any privileges as a user, but privileges on spesific databases for the user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL user privileges
Hi, All my MySQL users have access to all databases and all tables, allthough I've only given them access to one. How can I correct this? Is it possible to have them *only* see their database when i.e. typing 'show databases;', and also refuse them connection to any database but their own? Thanks in advance. Best regards, Haakon Nilsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL user privileges
H?kon Nilsen \(Exinet AS\) [EMAIL PROTECTED] wrote: All my MySQL users have access to all databases and all tables, allthough I've only given them access to one. How can I correct this? Do you have entry for anonymous user in the table 'user'? Is it possible to have them *only* see their database when i.e. typing 'show databases;', and also refuse them connection to any database but their own? If you use 3.23.xx you should run mysqld with --safe-show-database option: http://www.mysql.com/doc/en/Command-line_options.html From 4.0 user should have 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL user privileges
Thank you, Egor, I *had* the anonymous user, but I deleted it since I couldn't find the use for it. But I figured out what the problem was. I was using --safe-show-database, but it didn't seem to work. My error was that I gave users privileges. I also gave the privileges to the user on the database. So I removed the privileges on the user (select, insert, delete, insert), and then it worked. So, now the users don't have any privileges as a user, but privileges on spesific databases for the user. Thanks! Best regards, Haakon Nilsen - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 22, 2003 2:32 PM Subject: Re: MySQL user privileges H?kon Nilsen \(Exinet AS\) [EMAIL PROTECTED] wrote: All my MySQL users have access to all databases and all tables, allthough I've only given them access to one. How can I correct this? Do you have entry for anonymous user in the table 'user'? Is it possible to have them *only* see their database when i.e. typing 'show databases;', and also refuse them connection to any database but their own? If you use 3.23.xx you should run mysqld with --safe-show-database option: http://www.mysql.com/doc/en/Command-line_options.html From 4.0 user should have 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Do I need to create a mysql user in order to run mysql
I download a pre-compiled mysql from sunfreeware.com. When I run ./safe_mysqld , I was told the there is not mysql id. When I run mysql -help. I got the error message: ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Any advice? Ed _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - 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: create mysql user?? how
Actually, i'm sorry. I don't know why i didn't put a little more thought into what i was writting. another late night i guess. That wasn't very cool of me at all. My appologies, seriously. Though, the time was not wasted, i've been were you seem to be before, and none of the time anyone helped me went wasted (hopfully), so i assume the same from everyone else. And i did respond...with a very good, or atleast reasonable answer to your question...i think. I should have just left off the whole sentence within the ( )'s, cause it was rude... Sorry again. -Chris On Wednesday 22 January 2003 10:12 am, you wrote: hey, i am really sorry to waste your valuable time.. and again sorry that you wasted unneeded time to send back a response... thanks From: Dr. Poo [EMAIL PROTECTED] To: M A [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: create mysql user?? how Date: Wed, 22 Jan 2003 23:29:35 -0600 How about (not to be rude, but that do it for me!! attitude should not be accepted) you go to mysql.com, or google and type in those same two questions... Much faster. -Chris On Tuesday 21 January 2003 07:16 pm, M A wrote: hi, would someone please tell me how to create mysql user? and how to set the mysql root password? Thanks _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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 _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: create mysql user?? how
On Wednesday 22 January 2003 03:16, M A wrote: would someone please tell me how to create mysql user? and how to set the mysql root password? Please, check the following sections of the manual. There are a lot of info concerning your question: http://www.mysql.com/doc/en/Passwords.html http://www.mysql.com/doc/en/Default_privileges.html http://www.mysql.com/doc/en/Adding_users.html http://www.mysql.com/doc/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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
create mysql user?? how
hi, would someone please tell me how to create mysql user? and how to set the mysql root password? Thanks _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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: create mysql user?? how
How about (not to be rude, but that do it for me!! attitude should not be accepted) you go to mysql.com, or google and type in those same two questions... Much faster. -Chris On Tuesday 21 January 2003 07:16 pm, M A wrote: hi, would someone please tell me how to create mysql user? and how to set the mysql root password? Thanks _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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
Re: MySQL user privilages
Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error message... ERRO 1064: You have an error in you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2 Any help would be appreciated. TIA, Ryan --- Paul DuBois [EMAIL PROTECTED] wrote: At 9:25 -0800 12/8/02, Ryan McDougall wrote: Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY databases he wants and delete them if he no longer needs them, but at that same time not be able to mess with ANY other privileges or anyone elses DBs. That's not how it works. You can grant privileges for any database, but you can't grant privileges for any database except certain databases. One thing that may help is that you can use a pattern to specify the database name in the GRANT statement. Then the user can create any database that has a name matching the pattern. For example, GRANT ALL ON xyz%.* ... will allow the user to create and mess with any database having a name that begins with xyz. The only other way I can think of it to compare it to a windows situation. Lets say I'm in Windows and I start up MS Access... Now with me being a Windows user I can create any DB I want and do whatever I want to the DBs I've created (as long as its not in a read only folder) but I can't see or do anything to to the other peoples creations becuase I don't have permissions to do so. Am I going to have to, as root or another super user, create his DBs for him and then give him privileges to them? I just don't get how that sort of situation works in a production environment. But then again in a production environment you don't usually have people just creating DBs at will. Again sorry for my complete lack of understanding on this and stupidity, but my brain just will not wrap itself around this issue. You're probably trying to understand the MySQL privilege system as analogous to some other type of privilege system. Try to understand it as itself and you'll probably get farther. Thanx for all the help so far, Ryan McDougall __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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
re: Re: MySQL user privilages
On Thursday 12 December 2002 10:03, Ryan McDougall wrote: Alright I have tried to do the grant like the following: GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON user%.* TO user@% IDENTIFIED BY password; With no luck I keep getting an error message... ERRO 1064: You have an error in you SQL syntax near 'usre%.* To user@% IDENTIFIED BY password at line 2 Use backticks. mysql GRANT ALTER,CREATE,DELETE,DROP,INDEX,SELECT,UPDATE ON `user%`.* TO 'user'@'%' IDENTIFIED BY password; Query OK, 0 rows affected (0.01 sec) -- 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
Re: MySQL user privilages
Dear Ryan, have a look at the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management With the exception of Paul's book on MySQL, you probably won't find a better explanation of the MySQL privilege system. PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say anything about what EXACTLY a user can/can't touch with which privilages Just in short: Put this in my.cnf / my.ini: [mysqld] safe-show-database This will prevent MySQL users to see databases to which they have no access privilege. Starting with MySQL 4.0.5a, this have changed. Now, there is a special privilege show_database which is set to N by default. safe-show-database will still work, though. grant select,insert,update,delete,create,drop on somedb.* to someusr@% identified by 'passwrd'; This means, someusr can access the somedb database and all its tables from anywhere (%). someusr can create and drop tables, and might even drop database somedb, but cannot add or drop any other databases. So this should be exactly what you want. If applicable, you may want to restrict the access to something which is not %, but rather something like 192.168.% (e. g. intranet users) or even 62.115.92.78 (if your users have a static ip address). HTH! -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Ryan McDougall [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Sunday, December 08, 2002 6:39 AM Subject: MySQL user privilages Hey everyone, Ok if I issue this command: mysql grant select,insert,update,delete,create,drop - on *.* to someusr@% identified by 'passwrd'; I already know that this statement creates the user someusr w/ password=passwrd and it can connect from anywhere. What I don't know: Can this user now mess up the privilage tables? Can this user mess with other users DBs and tables? I want to create a normal user for me that can create my own DBs and delete them if I want (it my stuff anyway ) but I don't want me to be able to see or do anything to anybody elses stuff. Would I then have to run this command??? mysql grant select,insert,update,delete,create,drop - on somedb.* to someusr@% identified by 'passwrd'; And create this test DB so that this user can have initial privilages on some DB then that user will be ale to create their own DBs at will?? I just don't get the whole user aspect of MySQL... I want it to be like a normal *nix user create their own crap and delete it if they want... but don't touch whats not theirs! Is this accomplished with either of those commands, if so which one, if not how do I do that? PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say anything about what EXACTLY a user can/can't touch with which privilages __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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
Re: MySQL user privilages
Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY databases he wants and delete them if he no longer needs them, but at that same time not be able to mess with ANY other privileges or anyone elses DBs. The only other way I can think of it to compare it to a windows situation. Lets say I'm in Windows and I start up MS Access... Now with me being a Windows user I can create any DB I want and do whatever I want to the DBs I've created (as long as its not in a read only folder) but I can't see or do anything to to the other peoples creations becuase I don't have permissions to do so. Am I going to have to, as root or another super user, create his DBs for him and then give him privileges to them? I just don't get how that sort of situation works in a production environment. But then again in a production environment you don't usually have people just creating DBs at will. Again sorry for my complete lack of understanding on this and stupidity, but my brain just will not wrap itself around this issue. Thanx for all the help so far, Ryan McDougall --- Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote: Dear Ryan, have a look at the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management With the exception of Paul's book on MySQL, you probably won't find a better explanation of the MySQL privilege system. PLEASE I'M GOING CRAZY trying to figure this out... my book doesn't say anything about what EXACTLY a user can/can't touch with which privilages Just in short: Put this in my.cnf / my.ini: [mysqld] safe-show-database This will prevent MySQL users to see databases to which they have no access privilege. Starting with MySQL 4.0.5a, this have changed. Now, there is a special privilege show_database which is set to N by default. safe-show-database will still work, though. grant select,insert,update,delete,create,drop on somedb.* to someusr@% identified by 'passwrd'; This means, someusr can access the somedb database and all its tables from anywhere (%). someusr can create and drop tables, and might even drop database somedb, but cannot add or drop any other databases. So this should be exactly what you want. If applicable, you may want to restrict the access to something which is not %, but rather something like 192.168.% (e. g. intranet users) or even 62.115.92.78 (if your users have a static ip address). HTH! -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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
Want to create mySQL user through phpMyAdmin
I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program ? $conn = @mysql_connect (localhost:/usr/home/nets/mysql/mysql-demo.sock, manisha, pass); echo(before conn a); if ($conn){ mysql_select_db (demo); echo(conn got it); } ? but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha - 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: Want to create mySQL user through phpMyAdmin
Did you reload the privileges? --Joe On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote: I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program ? $conn = @mysql_connect (localhost:/usr/home/nets/mysql/mysql-demo.sock, manisha, pass); echo(before conn a); if ($conn){ mysql_select_db (demo); echo(conn got it); } ? but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha - 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 -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - 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: Want to create mySQL user through phpMyAdmin
I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do not know how to reload it ? I am not finding any such option on it. Can u please tell me more about it. Thanks, Manisha At 09:45 PM 12/8/02 -0500, Joe Stump wrote: Did you reload the privileges? --Joe On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote: I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program ? $conn = @mysql_connect (localhost:/usr/home/nets/mysql/mysql-demo.sock, manisha, pass); echo(before conn a); if ($conn){ mysql_select_db (demo); echo(conn got it); } ? but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha - 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 -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - 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: Want to create mySQL user through phpMyAdmin
oh! god! - Thanks a lot, I have a root access and with that I could create a user directly from command line. I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but seems not this version) Thanks once again Manisha At 10:21 PM 12/8/02 -0500, Joe Stump wrote: It's not a phpMyAdmin function. If you can run raw SQL against the DB try running this: FLUSH PRIVILEGES; But you'll need to be root. If you have access to the command line you can flush them with mysqladmin. Check out http://www.mysql.com/doc/en/Adding_users.html for more information. In the future you might want to check the manual and mailing list archives before posting. --Joe On Sunday, December 8, 2002, at 10:08 PM, Manisha wrote: I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do not know how to reload it ? I am not finding any such option on it. Can u please tell me more about it. Thanks, Manisha At 09:45 PM 12/8/02 -0500, Joe Stump wrote: Did you reload the privileges? --Joe On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote: I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program ? $conn = @mysql_connect (localhost:/usr/home/nets/mysql/mysql-demo.sock, manisha, pass); echo(before conn a); if ($conn){ mysql_select_db (demo); echo(conn got it); } ? but not getting the connection - if try with old user and password - can get connected what's wrong ? regards Manisha - 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 -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - 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 -- Joe Stump - [EMAIL PROTECTED] Software never has bugs. It just develops random features. - 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