LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 03-29-2005, 03:34 AM   #1
b:z
Member
 
Registered: Mar 2005
Posts: 146

Rep: Reputation: 15
Mysql - Howto insert 'admin' account into table ???


Hello, I'm a newbie in mysql, so i have a problem when managing my database.
This is one of table in my database:
==================================

+---------------+----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+----------------------+------+-----+---------------------+----------------+
| id | smallint(5) unsigned | | PRI | NULL | auto_increment |
| name | varchar(40) | | | | |
| login | varchar(20) | | | | |
| tester | tinyint(3) unsigned | | | 0 | |
| dev | tinyint(3) unsigned | | | 0 | |
| man | tinyint(3) unsigned | | | 0 | |
| security | smallint(5) unsigned | | | 0 | |
| password | varchar(32) | | | | |
| tz | time | | | 00:00:00 | |
| email | varchar(40) | | | | |
| spam | text | YES | | NULL | |
| creation_date | datetime | | | 0000-00-00 00:00:00 | |
| updated_date | datetime | YES | | NULL | |
| updated_by | varchar(40) | YES | | NULL | |
| note | text | YES | | NULL | |
| options | int(11) | YES | | NULL | |
| active | tinyint(4) | | | 1 | |
| hqflag | tinyint(1) unsigned | | | 0 | |
| usermask | int(11) | | | 1 | |
+---------------+----------------------+------+-----+---------------------+----------------+

=====================================
- How can i create an account with full control into the database or that tables?
- How can i create an account with restrict permission in my database?
- How many kinds of accounts can i create?
Please help me solve the problem.
Thanks so much.
 
Old 03-29-2005, 03:44 AM   #2
Orkie
Member
 
Registered: Mar 2005
Distribution: Breezy Badger
Posts: 248

Rep: Reputation: 30
If you are new to MySQL, it may be worth grabbing MySQL Administrator, that allows you to create accounts and set permissions really easily.
 
Old 03-29-2005, 03:53 AM   #3
b:z
Member
 
Registered: Mar 2005
Posts: 146

Original Poster
Rep: Reputation: 15
ok, thanks for your answer, however is MySQL Administrator software?
How about my problem, can you show me the way to solve it?
Thansk so much.
 
Old 03-29-2005, 04:15 AM   #4
Orkie
Member
 
Registered: Mar 2005
Distribution: Breezy Badger
Posts: 248

Rep: Reputation: 30
MySQL Administrator is a really nice GUI way to manage MySQL. You can get it from http://www.mysql.com/products/administrator/. Once you have installed the program, launch it and it is easy to manage user accounts. To change permissions on an account, you simply select the account, select the database, select the permissions you would like that account to have and click a button. It is hard to explain a GUI app through text but it is so easy to use, once you have it, it won't pose any program.
 
Old 03-29-2005, 04:19 AM   #5
b:z
Member
 
Registered: Mar 2005
Posts: 146

Original Poster
Rep: Reputation: 15
Thanks for your guide, however in my problem. I want to insert a username into my table above. Please help me.
I will get MySQL Administratror, however please help me solve the problem.
Thanks
 
Old 03-29-2005, 04:29 AM   #6
Orkie
Member
 
Registered: Mar 2005
Distribution: Breezy Badger
Posts: 248

Rep: Reputation: 30
Do you want to insert a username field into the table or insert a row with the username in the 'name' field?

If you just want to add a username field, Administrator can do that too. On the menu, at the bottom it says 'Catalogs', choose that, then the database that your table is in. A list of tables in that database will appear, double click on the table you wish to edit and scroll to the bottom of the new window, just type the details in there and apply it.
 
Old 03-29-2005, 04:44 AM   #7
b:z
Member
 
Registered: Mar 2005
Posts: 146

Original Poster
Rep: Reputation: 15
ok, thanks for all. I have solved the problem.
- Get phpMyadmin
- Do with my idea.

Thanks again
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Making an account an admin? sleepykit Mandriva 9 11-23-2005 06:51 PM
How to insert same text in one field for 10,000 records table edhan Linux - Newbie 6 06-13-2005 04:48 AM
admin account recovery rajivb Linux - Newbie 4 02-20-2005 03:06 AM
domain admin account ? alris Linux - Networking 0 11-01-2004 09:15 PM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 12:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 10:40 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration