LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 03-19-2003, 07:59 PM   #1
nakkaya
Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Rep: Reputation: 45
tuning mysql


i am working on a project that is mainly uses mysql database and i am looking for a way to tune mysql any articles and how tos are highly welcome thx in advance
 
Old 03-19-2003, 08:00 PM   #2
nakkaya
Guru
 
Registered: Jan 2003
Location: Turkey&USA
Distribution: Emacs and linux is its device driver(Slackware,redhat)
Posts: 1,398

Original Poster
Rep: Reputation: 45
and one more thing how can i configure mysql to just accept connections from localhost
 
Old 03-20-2003, 05:28 AM   #3
niehls
Member
 
Registered: Jun 2002
Location: Sweden
Distribution: slack, redhat
Posts: 91

Rep: Reputation: 15
Mysql has the "mysql" database by default. in this database are various tables defining the rights of the different users allowed to access the database. in the "user" table you can set the host from which the users are allowed to connect. if you use user name "foo" and password "bar" to log in to the database, simply set the host column to localhost where user name = foo, to accept only connections from localhost when this user is connecting to the database.

hope this made sense.

cheers.
 
  


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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
server tuning mufy Linux - General 1 01-04-2005 05:02 AM
Apache & MySQL keep becoming unresponsive, tuning? chotgor1 Linux - Software 2 11-03-2004 12:37 PM
Tuning Linux... hkxx9 Linux - Newbie 5 09-16-2004 07:30 AM
Need help on tuning my connection SlackN00b Slackware 0 01-08-2004 05:43 PM


All times are GMT -5. The time now is 04:10 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration