Fedora Linux Support Community & Resources Center
  #1  
Old 1st September 2008, 09:59 AM
Ghroth Offline
Registered User
 
Join Date: Sep 2008
Posts: 3
Setting up MySQL server

Hi there. First of all i would like to introduce myself since this is my very first post.
My name is Jim and i'm from Greece. AND i'm pretty new to the linux. I chose to install FC9. servering httpd, php and mysql. So far, i had no problem with http and php but i'm having troubles with mysql.
Here it goes:

i've installed mysql.i386 (5.0.51a-1.fc9.i386.rpm) and mysql-server.i386 (5.0.51a-1.fc9) via yum with all their dependencies.: When i try to run the service, ("mysql start") i get the error:
Code:
[root@localhost /]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Searching a little bit deeper i found that this error's coming from /etc/my.cnf:
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql.sock
user=mysql
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Further more i found that the file "mysql.sock" is generated automatically when mysqld is starting but still no results from "find -name mysql.sock". And yup i can see the service mysqld running.

Sorry if this problem is kinda "newbie" to you. Any kind of help would be really appreciated.
Thank you in advance.
Reply With Quote
  #2  
Old 1st September 2008, 10:44 AM
AlexDudko Offline
Registered User
 
Join Date: Mar 2007
Location: Ukraine
Posts: 381
First, try this command to start the server: /etc/rc.d/init.d/mysqld start
After the server starts you can use it in terminal starting the mysql command line with command mysql
Reply With Quote
  #3  
Old 1st September 2008, 10:57 AM
Ghroth Offline
Registered User
 
Join Date: Sep 2008
Posts: 3
Thank you for really fast replying

Strangely I get this now:
Code:
[root@localhost /]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]
So.. the service cannot start at all.. I must search about what's wrong with the mysqld.

Edit:
Ok, I changed the user from "mysql" to "root" inside the my.cnf and mysqld is running correctly. And i can see the mysql.conf inside the /var/lib/mysql folder.. but still getting the same error..

Last edited by Ghroth; 1st September 2008 at 11:07 AM.
Reply With Quote
  #4  
Old 1st September 2008, 12:58 PM
Ghroth Offline
Registered User
 
Join Date: Sep 2008
Posts: 3
Nice, I solved it. I noticed that, the actual path of the mysql.conf that mysql is trying to locate is the '/var/lib/mysql/mysql.sock' but the actual mysql.sock has been generated as '/var/lib/mysql.sock'. So, i tried to make a link like "ln -s /var/lib/mysql.sock /var/lib/mysql/mysql.sock" and it got fixed. (i'm a fast learner )

Hope for no more problems.
Reply With Quote
Reply

Tags
mysql, server, setting

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up Fedora Directoy Server as LDAP Address book server: how? mdragt Servers & Networking 0 17th September 2008 12:20 PM
Setting MySQL to a different IP NinjaTails Servers & Networking 4 23rd May 2007 02:10 AM
How to install mysql MySQL-server-4.0.26-0 FC2 or Upgrade 3.23.58-16.FC2.1 from to 4 niloshima EOL (End Of Life) Versions 1 28th October 2005 06:25 PM
Install mail server from Postfix/CyrusSASL2/PAM-MySQL/MySQL/Dovecot/Amavisd/Clamav chengcsw Guides & Solutions (No Questions) 7 26th April 2005 08:38 PM
Setting up mySql explosive Using Fedora 14 25th March 2005 08:10 PM


Current GMT-time: 13:45 (Thursday, 30-10-2014)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat
Lodz Travel Photos on Instagram - Masumbwe - Tiangua Photos on Instagram