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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
06-03-2005, 11:49 PM
|
#1
|
Member
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330
Rep:
|
How to start mysqld without the skip networking option?
Dear friends,
I am trying to configure knowledgetree with its fileindexer.
I need to start mysqld without the "skip networking" option. I looked into the config file /etc/my.cnf doesn't have the skip networking option in there. heres the my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Seems short and simple. No skip-networking option to be uncommented.
Someone teach me :
start mysqld
with the "--skip-networking" option.
but I don't want it to start with skip-networking, how do I do that? thanks a lot for taking time reading my mail!
|
|
|
06-05-2005, 11:33 AM
|
#2
|
Senior Member
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690
Rep:
|
What is your problem? If you want the skip-networking option add it else leave your configuration file like it is.
|
|
|
06-07-2005, 03:01 AM
|
#3
|
Member
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330
Original Poster
Rep:
|
Hi mrcheeks,
Thanks for your help,
My problem is that, seems like my mysql cannot listen with TCP. I am trying to configure fileindexer for knowledgeTree, and getting error which might be caused by my mysql's inability to listen through TCP. Someone in forum told me to try
mysql -u root -h 127.0.0.1 -P3306 , if it works then its listening through TCP. but I got error as below:
ERROR 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
Someone also told me to mysql to listen through TCP, I have to comment the "skip networking" option so that it doesn't not skip networking.
I tried to do that but my my.cnf config file doesn't have such option, in fact my my.cnf is very simple and short as below:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
My spec:
fc2
mysql-3.23.58-9
(Everything I am using comes with distribution)
So, what I need is to enable mysql to listen through TCP...but can't figure out how to...,,,
thanks a lot for your help sir.
|
|
|
06-07-2005, 03:26 AM
|
#4
|
LQ Newbie
Registered: Jun 2005
Location: Glasgow, Scotland
Distribution: Debian
Posts: 12
Rep:
|
Paste here exactly what happens when you type:
mysql -u root -p
|
|
|
06-07-2005, 07:07 AM
|
#5
|
Senior Member
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690
Rep:
|
do you have a firewall?
|
|
|
06-07-2005, 07:36 PM
|
#6
|
Member
Registered: Nov 2004
Distribution: Fedora Core 2
Posts: 330
Original Poster
Rep:
|
Dear friends,
Thanks a lot for helping! I have got it sorted out.
the error msg I got: ERROR 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
What I did I just give permission to host = localhost.localdomain in mysql. After that it works....I am so stupid....
Now my indexer and archiver for knowledgetree works.
Thanks a lot guys for helping,
|
|
|
All times are GMT -5. The time now is 04:16 AM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|