Remove 'debian-sys-maint' Account?
I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 installed. It is a fresh install and I was checking all the system accounts and noticed that Debian has a 'debian-sys-maint' account on 'localhost'. Has anyone ever removed this account? Do I need it or can I safely remove this account? I don't understand why it's there. I don't want to break MySQL even though there is no data or databases on this machine but I would like to keep this as clean as possible. Thanks for any input. -Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to purposely corrupt a table
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons jlyons4...@gmail.com wrote: I have a script that does this. It goes through every table in every database (excluding specific database like information_schema, etc) and issues the command: select 1 from db.tab limit 1; Interesting. Would you mind sharing the script? Is it PHP? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Missing Entries
I already set the root password for the MySQL root user. That is why in my 1st email you see the encrypted password listed for root in localhost, mail, 127.0.0.1. Thanks for all your info. I followed Neil's steps and it worked perfect...after I realised that those were two 's and not a single quote () at the end of the delete command. Thanks for your support! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Missing Entries
I was checking my fresh install of MySQL and noticed I had empt spaces or missing entries in some sections when I did a search for users on the 'mysql' database. I checked the MySQL FAQ's and Google and nothing gave me what I am looking for. I can't understand what this entries are blank for: mysql select User, Password, Host, Insert_priv from user; ++---+---+-+ | User | Password | Host | Insert_priv | ++---+---+-+ | root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | Y | | root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | mail | Y | | root | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | 127.0.0.1 | Y | || | localhost | N | || | mail | N | | carlos | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | N | ++---+---+-+ I see there are 3 root users: - localhost - mail (hostname) - 127.0.0.1 (localhost IP) But after that there are two entries that are blank for 'localhost' 'mail'. Does anyone know what they are and if I can remove them. They appear useless and clutter my database. Sorry, I am OCD. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Unable To Remove User
On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm wrote: Why don't you just say Drop User carlos? Also are you logged in as root? In my original message to the board I demonstrated the error I get on my server when I attempt to run the 'drop user 'carlos'@'localhost'; command. Why can't I remove this user from MySQL? I am logged in as root on both Linux and MySQL so I don't see why I can't remove 'carlos'@'localhost'. It's as if MySQL doesn't understand this user exist. He might not exist because I can't login as him however I need this entry removed from the user table. [r...@tiger ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.1.38 Source distribution mysql show grants for 'carlos'@'localhost'; ERROR 1141 (42000): There is no such grant defined for user 'carlos' on host 'localhost' mysql use mysql; 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 select User, Host from user; +++ | User | Host | +++ | carlos | localhost | | root | localhost | +++ 2 rows in set (0.00 sec) mysql drop user 'carlos'@'localhost'; ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Unable To Remove User
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty mgai...@hotmail.com wrote: Grant he is trying to login as that user then drop the user he logged in as No, no and no. I clearly showed my commands including my login to MySQL as root. I also cleanly noted I can't even login as the user I am trying to delete. I will try Claudio's suggestion and post back my results. I find it odd that the output of users has a carriage return in it which malformed the table output. It's not normally like that so you're possibly right and that could be the issue! Either way I hope Claudio's instructions resolve it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Adding Fields To Table
I am no doubt very new to MySQL and have been studying the on line manual however I find it a bit complex and don't understand what it's suggesting I do in this case. I created a database called 'staff' and then in that database I created one simple table: mysql show tables; +-+ | Tables_in_staff | +-+ | it | +-+ 1 row in set (0.00 sec) mysql describe it; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | name | varchar(40) | YES | | NULL| | | username | varchar(20) | YES | | NULL| | | email| varchar(20) | YES | | NULL| | | office | char(3) | YES | | NULL| | +--+-+--+-+-+---+ 4 rows in set (0.00 sec) My question is if I would like to add addition fields like 'title' 'phone number', how can I modify the table fields entry to add more fields? Thanks for any help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Adding Fields To Table
On Wed, Sep 30, 2009 at 1:11 PM, mos mo...@fastmail.fm wrote: Carlos, Get a free copy of SqlYog (Community edition). http://code.google.com/p/sqlyog/ Thanks but I don't have any GUI's installed on my machine I manage the database on or from. I am also trying to learn in case things break and I only have access to CLI. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Unable To Remove User
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni claudio.na...@gmail.com wrote: Remove manually (delete) the user from all the privilege tables: delete from columns_priv where user='carlos'; delete from db where user='carlos'; delete from procs_priv where user='carlos'; delete from tables_priv where user='carlos'; delete from user where user='carlos'; then a nice FLUSH PRIVILEGES; this should fix, let me know! Worked great!!! mysql select User, Host, Password from user; +--+---+---+ | User | Host | Password | +--+---+---+ | root | localhost | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | +--+---+---+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Unable To Remove User
I just created a generic test user account on MySQL 5.1 and now for some reason I am unable to remove him... mysql use mysql; 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 select User, Host from user; +++ | User | Host | +++ | carlos | localhost | | root | localhost | +++ 2 rows in set (0.01 sec) I obviously from above have a user name 'carlos'@'localhost' when I try to delete him, I get the following: mysql drop user 'carlos'@'localhost'; ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' Can someone please help me understand why I am unable to remove this user from MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Properly Use Replace Command
I know this seems very basic and I checked Google before posting but
it appears that many of the manuals / guides online reference
something a bit more extreme than what I am looking for.
I am searching a table called 'identities' and in that table there is
a column called 'email'. Some people have the wrong email address
listed so I would like to replace the invalid entry
'u...@mail.iamghost.com' to the correct value 'u...@iamghost.com'
mysql select email from identities where email like ('%mail.iamghost.com');
I ran the above command to show me all the people with the invalid
email address. Now I am just looking for a way to change mutiple
incorrect entries in one command. Is this possible in MySQL?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Properly Use Replace Command
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivannsulli...@cappex.com wrote:
Carlos,
I think this does what you want: (untested though)
UPDATE identities
SET email=replace(email, 'mail.', '')
WHERE email like '%mail.iamghost.com'
That worked perfect!
UPDATE identities
- SET email=replace(email, 'mail.', '')
- WHERE email like '%mail.iamghost.com';
Query OK, 47 rows affected (0.01 sec)
Rows matched: 47 Changed: 47 Warnings: 0
mysql select name, email from identities where email like
('%mail.iamghost.com');
Empty set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL GUI Tools
If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? -- 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 GUI Tools
Yup. That was what I was looking for. Thanks! On Mon, Jul 13, 2009 at 3:27 PM, Rayr...@stilltech.net wrote: On July 13, 2009 12:03:49 pm Carlos Williams wrote: If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you guys recommend? I have been doing everything via CLI only and would like to try a GUI option if available. Anyone know if this exist for Linux? PhpMyAdmin http://www.phpmyadmin.net/home_page/index.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=carlosw...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How To Clean Old Table Data
I have an application that crates a users email info in MySQL every time they login into the application. The only problem is once I remove their account from the application/Linux, their user data remains in the MySQL table and will eventually clutter the database. I don't know how I should or can set something up that when I remove someone from the Linux system, I can also remove their data from MySQL. mysql select * from identities; +-+-+--+-+--+---+--+-+++-+ | identity_id | del | standard | name| organization | email | reply-to | bcc | signature | html_signature | user_id | +-+-+--+-+--+---+--+-+++-+ | 1 | 0 |1 | Carlos Williams | | j...@mdamusic.com car...@ideorlando.org | | | -- Carlos | 0 | 1 | | 2 | 0 |1 | carlos | | car...@mdamusic.com car...@ideorlando.org | | | NULL | 0 | 2 | | 3 | 0 |1 | Carlos Williams | | ja...@mdamusic.com car...@iamunix.com | | | Carlos | 0 | 3 | +-+-+--+-+--+---+--+-+++-+ 3 rows in set (0.00 sec) Above I have connected to the database and I can see 3 users that are no longer present on the server however their user data is still stored in MySQL. How can I delete the entire row of data in the table.
How To Clean Old Table Data
I have an application that crates a users email info in MySQL every time they login into the application. The only problem is once I remove their account from the application/Linux, their user data remains in the MySQL table and will eventually clutter the database. I don't know how I should or can set something up that when I remove someone from the Linux system, I can also remove their data from MySQL. mysql select * from identities; +-+-+--+-+--+---+--+-+++-+ | identity_id | del | standard | name| organization | email | reply-to | bcc | signature | html_signature | user_id | +-+-+--+-+--+---+--+-+++-+ | 1 | 0 |1 | Carlos Williams | | car...@ideorlando.org | | | -- Carlos | 0 | 1 | | 2 | 0 |1 | carlos | | car...@ideorlando.org | | | NULL | 0 | 2 | | 3 | 0 |1 | Carlos Williams | | car...@iamunix.com| | | Carlos | 0 | 3 | +-+-+--+-+--+---+--+-+++-+ 3 rows in set (0.00 sec) Above I have connected to the database and I can see 3 users that are no longer present on the server however their user data is still stored in MySQL. How can I delete the entire row of data in the table.
Re: What OS is the best platform for MySQL ?
On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet blogtiengv...@yahoo.comwrote: Dear All, I have been using MySQL on FreeBSD for 3 years and encounterd a lot of problems related to thread management. And 1 year ago, I found that my FreeBSD box does not go well with any MySQL revision after 5.1.17-beta, because the MySQL thread does not end although complied with LINUX_THREADS. Now I want to chane platform for MySQL from FreeBSD to another OS. Is there any advice for choosing OS? I think any version of Linux is perfect with MySQL. It's optimized perfectly for MySQL. I use Debian but mileage may vary.
Re: Password Reset Not Working
Can someone please explain why I have 3 entries for root or if this is normal behavior for MySQL? I thought after a installation of MySQL, you normally have 2: 1 - localhost 2 - host.domain.com For some reason I had a 3rd entry: 3 - 127.0.0.1 I don't know if I did the right thing but I ran the following command: update user set host=localhost where host='127.0.0.1'; This basically changed the 127.0.0.1 entry in mysql databased, host section to localhost. I am not sure if MySQL needs to have the 3rd host entry for root that equals 127.0.0.1 or if it generally should just have the localhost and fqdn. Can anyone please clear this up for me? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Password Reset Not Working
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni claudio.na...@gmail.com wrote: I don't know if you are now more ore less confused! Claudio I would say less because you basically explained that I need to have localhost 127.0.0.1. Now my problem is that no longer have this and would like to know what I can do to resolve this by re-adding the 127.0.0.1 host / root user parameter back into MySQL. mysql use mysql; 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 select user, host, password from user; +---++--+ | user | host | password | +---++--+ | root | host.domain.com | 032c41e8435273a7 | | root | localhost | 032c41e8435273a7 | | roundcube | localhost | 032c41e8435273a7 | | mrbs | localhost | 6322a1af59897de4 | | phpbb| localhost | 5d2e19393cc5ef67 | +---++--+ 5 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Password Reset Not Working
I noticed today that I strangely was unable to login to MySQL as root. I just assumed I forgot the password and decided to reset my root password: 1 - /etc/init.d/mysqld stop 2 - mysqld_safe --skip-grant-tables 3 - mysql -u root 4 - mysql use mysql; mysql mysql update user set password='letmein' where user='root'; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql flush privileges; mysql quit 5 - /etc/init.d/mysqld restart *Now after I do all that, I get the following:* mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I have done this over and over and can't login so I am wondering if something is wrong with MySQL or am I just not properly resetting the password... Someone please help! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Password Reset Not Working
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal carlos.pr...@gmail.com wrote:
Hi Carlos
Try this
mysql update user set password=password('letmein') where user='root';
This way the password is saved encrypted, thats the way is compared when you
try to log in.
Thanks for the reply! I followed both methods in the following URL / link:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
After doing both successfully, I was unable to login over and over. I
think something is wrong with MySQL. I have never seen this before :(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Password Reset Not Working
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal carlos.pr...@gmail.com wrote: Check how many root rows do you have on the user table (select * from user where user='root';), some times there are several rows with different grants and probably you are going through and invalid rule. I checked and when I ran the command you suggested: mysql use mysql; Database changed mysql select * from user where user='root'; I get a bunch of gibberish on the screen but the only thing I can make out are two entries for root: | mysql.unixslut.com | root | 6d21bd9609b168e4 | Y | Y | Y | 127.0.0.1| root | 6d21bd9609b168e4 | Y | Y | Y So what does this mean and how can I resolve this? I am trying this from the machine locally so I would assume localhost works fine... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Password Reset Not Working
On Thu, May 14, 2009 at 7:06 PM, Carlos Proal carlos.pr...@gmail.com wrote: The machine mysql.unixslut.com is not the same than localhost, right ??, If you only need root access from localhost you can delete the first row (delete from user where user='root' and host='mysql.unixslut.com';) Carlos, Yes, my machine mysql.unixslut.com is localhost / 127.0.0.1/8. They're both the same machine. It's just that I was told MySQL manages connection for users on a local / domain basis so that is the reason for both entries. In my opinion, both entries are valid. I could be wrong. **No, the server has not been hacked** Thanks for your continued support!] - Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Password Reset Not Working
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson douglas.nel...@sun.com wrote: try running the command like this select * from user where user='root' \G Capital G is a must. I did the following: [r...@mysql ~]# /etc/init.d/mysqld stop Stopping MySQL:[ OK ] [r...@mysql ~]# mysqld_safe --skip-grant-tables [1] 3072 Starting mysqld daemon with databases from /var/lib/mysql [r...@mysql ~]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; 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 select * from user where user='root' \G *** 1. row *** Host: mysql.unixslut.com User: root Password: 6d24bd789879jhs Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 *** 2. row *** Host: 127.0.0.1 User: root Password: 6d24bd789879jhs Select_priv: Y Insert_priv: Y Update_priv: Y Delete_priv: Y Create_priv: Y Drop_priv: Y Reload_priv: Y Shutdown_priv: Y Process_priv: Y File_priv: Y Grant_priv: Y References_priv: Y Index_priv: Y Alter_priv: Y Show_db_priv: Y Super_priv: Y Create_tmp_table_priv: Y Lock_tables_priv: Y Execute_priv: Y Repl_slave_priv: Y Repl_client_priv: Y Create_view_priv: Y Show_view_priv: Y Create_routine_priv: Y Alter_routine_priv: Y Create_user_priv: Y ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 max_user_connections: 0 2 rows in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Creating a New DB / User
I have used MySQL twice in my career so I did read the MySQL How-to page and just wanted to ask here if what I did as correct based on what I wanted to do. I just wanted to create a new database in MySQL called webmail and then also create a new user who limited to only accessing the 'webmail' database and nothing else. Can someone please tell me if I did this correctly or if I messed up and mis-understood the instructions. I am sure there are easier ways to do this via mysql-admin tool but I prefer to just try the way below unless its dead wrong... === Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 437 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | cal| | forums | | it | | mysql | ++ 5 rows in set (0.00 sec) mysql create database webmail; Query OK, 1 row affected (0.00 sec) mysql grant all privileges on webmail.* to dub...@localhost identified by 'n...@ke$' with grant option; Query OK, 0 rows affected (0.00 sec) === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Creating a New DB / User
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman mdyk...@gmail.com wrote: One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. How do I change the bit for 'grant all' via the CLI? What command would I run to keep the user as having full rights to the 'dublin' database but not being able to grant other users permissions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating a New DB / User
2009/5/13 Pintér Tibor tib...@tibyke.hu: how about reading the fine manual of the GRANT command at mysql.com? I did to avoid being lazy...go figure. I then decided to ask here before I make a mistake I felt the fine manual was not clear enough for me... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Creating / Lookup Users For Database
This seems to be a simple beginer question for MySQL and I have searched online but I wanted to ask before I really confuse myself. I have MySQL running on Linux and right now I have created a 2nd production database: mysql show databases; +-+ | Database| +-+ | information_schema | | cal | | forums| | mysql | +-+ I know when I created 'cal' I also created a specific user to have permissions to this database as I was told root was not a good idea. I don't remember who or what user I created so can someone please tell me how I am able to look up the user who has permissions to 'cal' database and I would also like to have that same user permissions to the new database I created called 'forums'. Sorry for my ignorance but I greatly appreciate any and all assistance to my question above! -- Carlos W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote: All user information is stored in the mysql database. If you want to see a list of users that have been created, query the user information table. select User, Host from mysql.user Then to see what access each user has, view the grants. show grants for usern...@hostname So I should do the following or am I missing something? == mysql use mysql; 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 show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db | | func | | help_category | | help_keyword | | help_relation | | help_topic | | host | | proc | | procs_priv | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---+ 17 rows in set (0.00 sec) == Now I have searched the Internet to find out how I can query that 'user' table. How can I find the command that will show my what is in the 'user' table?
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 2:45 PM, George Larson george.g.lar...@gmail.com wrote: Is this what you mean? SELECT * FROM user; Yes. That was exactly what I was looking for. Thank you for that info. Still learning these commands so pardon my ignorance. Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user and grant access to just that one specific 'forums' database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote: Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user and grant access to just that one specific 'forums' database. Is this correct assuming I already created the 'forums' database? mysql CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd'; mysql GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' - WITH GRANT OPTION; I don't know if the above is correct way to create a new user in MySQL and grant privileges only to access the 'forums' database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
