Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

setup of user a/c in mysql in linux

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers setup of user a/c in mysql in linux
# 1  
Old 04-19-2007
setup of user a/c in mysql in linux
Hi Friends,

I am new user of linux operating system. I wanted to install a software but facing a difficulty.

I am not able to proceed to the next statement without resolving this. WFT is the software i need for my purpose.

Setup a MySQL user account for WTF that will have access to
select, insert, update, and delete all "wtf" tables.

I have emerge the mysql 5.0.26 -r2 in my linux operating system.

can anyone please help me with this..


Regards,
Alma
# 2  
Old 04-19-2007
Login as root mysql user, and then use the grant command, e.g.

grant all privileges on db.* to 'user'@'localhost' identified by 'password'



http://dev.mysql.com/doc/refman/5.0/...istration.html

Read sect. 5.7 and sect. 5.8.
Last edited by cbkihong; 04-19-2007 at 09:05 PM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Setup Samba Server to always ask user and password

How do I setup a Samba server to always ask to user and password, when a windows user, prints your files using a shared printer through a Samba Linux Server (CUPS)? (0 Replies)
Discussion started by: viga
0 Replies

2. Web Development

MySQL Old Setup Files

Hi there, How is it possible to check that: 1) The old setup files are secured or deleted? For both windows or Unix (0 Replies)
Discussion started by: alvinoo
0 Replies

3. Shell Programming and Scripting

Check whether user has passwordless setup

Hello Unix scripters, I have created a small tool that i can distribute to users to check whether they have passwordless login to a list of servers. The problem in my code below is if user do not have the passwordless login yet, it will prompt them with a password login and my message below... (2 Replies)
Discussion started by: ryandegreat25
2 Replies

4. Linux

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Data source name not found, and no default driver specified ERROR: Could not SQLConnect ... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies

5. UNIX for Advanced & Expert Users

Setup SUDO For a User on Linux Server

Hello! Can anyone please assist: Question: On Linux Server I have created two users John and Matt. I want to give both the users the ability to run 'more' and 'tail -f' commands on the log file in the directory /var/log/test.log. I do not want to give them SU rights. Can any one please... (6 Replies)
Discussion started by: sureshcisco
6 Replies

6. UNIX for Dummies Questions & Answers

Setup of user groups and permissions

Hi folks, thanks for reading this. I have been asked to manage our company's SCO OpenServer 5 system since the old administrator left. I have a very basic knowledge of Unix, but only the basic commands - ls, ps, chmod, etc. This server holds thousands of programs (converted Basic programs,... (4 Replies)
Discussion started by: citygov
4 Replies

7. UNIX for Dummies Questions & Answers

New User/Mail setup question. PLEASE help.

OK, here's the situation. Our regular computer guy left the company without warning. We are in the process of replacing him with someone much more knowlegeable than I, but as of right now, I have been handed the duties. Our mail server is running OpenBSD and I need to set up a new employee with an... (3 Replies)
Discussion started by: Rotting
3 Replies

8. UNIX for Dummies Questions & Answers

setup a logfile for user login/logout ???

Hi everybody, im a newer, i want to setup a logfile to capture information about user login/logout (and some other events ex: a user ftp, run a speacial command) on my system in HP-UX, pls help me. i think only edit file /etc/syslog.conf but i dont know how to do it. Help me. (3 Replies)
Discussion started by: pwd
3 Replies

9. Solaris

user setup - only ftp access

I want to setup a user on my server and only allow that user to ftp to my server but not to be able to get to command line (telnet /ssh) I ammended my /etc/passwd so the users shell would be /usr/bin/false and this prevents log on but it also prevents the ftp.. Any ideas? (1 Reply)
Discussion started by: frustrated1
1 Replies
Login or Register to Ask a Question