LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   MYSQL (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-747899/)

smaj84_1 08-18-2009 07:12 AM

Quote:

Originally Posted by ThinkFree (Post 3645219)
will install mysql client as well as mysql server.Add

yum install mysql mysql-server apache2 php
will let install LAMP

I have downloaded and when I tried to start mysql I receieved this:
root@vps2 [/]# service mysql start
Starting MySQL ERROR! Couldn't find MySQL manager (/usr/local/bin/mysqlmanager) or server (/usr/local/bin/mysqld_safe)

Please guide me.

ThinkFree 08-18-2009 12:32 PM

mysql daemon is started using the command
Quote:

service mysqld start
on fedora.

smaj84_1 08-19-2009 01:11 AM

Quote:

Originally Posted by ThinkFree (Post 3648266)
mysql daemon is started using the command

on fedora.

It shows this:

root@vps2 [/]# service mysqld start
mysqld: unrecognized service

Tell me what should I do now?

smaj84_1 08-19-2009 02:00 AM

Quote:

Originally Posted by smaj84_1 (Post 3648964)
It shows this:

root@vps2 [/]# service mysqld start
mysqld: unrecognized service

Tell me what should I do now?


I have found these errors...
root@vps2 [/etc]# service mysqld start
mysqld: unrecognized service
root@vps2 [/etc]# service mysql start
Starting MySQL ERROR! Couldn't find MySQL manager (/usr/local/bin/mysqlmanager) or server (/usr/local/bin/mysqld_safe)
root@vps2 [/etc]# /etc/init.d/mysql start
Starting MySQL ERROR! Couldn't find MySQL manager (/usr/local/bin/mysqlmanager) or server (/usr/local/bin/mysqld_safe)
root@vps2 [/etc]# /etc/init.d/mysqld start
-bash: /etc/init.d/mysqld: No such file or directory
root@vps2 [/etc]# /etc/init.d/mysql.server start
Starting MySQL. SUCCESS!

It says Success but it doesnt really started I cannot access mysql command see this:
root@vps2 [/etc]# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
mysql.sock does not exist in /tmp. even mysql.sock does not exist anywhere..what should I do now?

ThinkFree 08-19-2009 07:03 AM

What output does command rpm -qa|grep mysql gives?
On my computer, it shows
Quote:

libdbi-dbd-mysql-0.8.3-4.fc11.i586
php-mysql-5.2.9-2.fc11.i586
mysql-libs-5.1.32-1.fc11.i586
mysql-connector-odbc-5.1.5r1144-4.fc11.i586
qt-mysql-4.5.2-1.fc11.i586
mysql-server-5.1.32-1.fc11.i586
mysql-embedded-5.1.32-1.fc11.i586
mysql-connector-java-3.1.12-7.fc11.i586
mysql-5.1.32-1.fc11.i586
You will be getting error 2002 if mysqld isn't started. As mysql isn't installed properly, you won't be able to login.

smaj84_1 08-19-2009 07:05 AM

Quote:

Originally Posted by ThinkFree (Post 3649295)
What output does command rpm -qa|grep mysql gives?
On my computer, it shows


You will be getting error 2002 if mysqld isn't started. As mysql isn't installed properly, you won't be able to login.

Here is the output:
-------------------------------------------------------------------------
root@vps2 [/]# rpm -qa|grep mysql
root@vps2 [/]#

-------------------------------------------------------------------------

ThinkFree 08-19-2009 07:28 AM

^Means mysql isn't installed properly.

smaj84_1 08-19-2009 08:23 AM

Quote:

Originally Posted by ThinkFree (Post 3649332)
^Means mysql isn't installed properly.

I have solved this by disabling Selinux..
Thanks anyway..:)

smaj84_1 08-19-2009 08:29 AM

Quote:

Originally Posted by smaj84_1 (Post 3649402)
I have solved this by disabling Selinux..
Thanks anyway..:)

Now I m facing 2 another problems...

1, I have to mention full path to start mysql i.e. /usr/local/mysql/bin/mysql -u root -p
Why I have to use full path?

2, MySQL automatically TERMINATE in less than a minute.

Please guide me.

Thanks in advance..:)

ThinkFree 08-19-2009 08:49 AM

^You didn't mention that you got any SELinux message. Next time onwards, provide all symptoms of your problem to get a speedy solution.

Tinkster 08-19-2009 12:20 PM

smaj84_1 ... I merged 3 of your closely related threads,
and ask you to not do this again in the future. Stick
with one thread if the problem relate to one issue.

Should I see you doing this again I'll just close your
dupes, and set a link to the existing threads in the
closure notice.


Cheers,
Tink

smaj84_1 08-20-2009 03:46 AM

Quote:

Originally Posted by Tinkster (Post 3649715)
smaj84_1 ... I merged 3 of your closely related threads,
and ask you to not do this again in the future. Stick
with one thread if the problem relate to one issue.

Should I see you doing this again I'll just close your
dupes, and set a link to the existing threads in the
closure notice.


Cheers,
Tink

Alright I will be careful next time...


All times are GMT -5. The time now is 02:24 PM.