General :: How To Install Mysql On Other HDD

Jun 20, 2011

I am installing Mysql 5.0 on Centos5.5 on different location. Like by default mysql rpm installs mysql in /var/lib partition but i want to install it on other HDD. So, i created a new partition on new HDD. The problem is in which configuration file of mysql i should change datadir and socket path because there are 4-5 configuration files i.e my-huge.cnf, my-large.cnf, my-medium.cnf, my-small.cnf etc.

I changed path in all these files by adding new datadir and socket line but after modifying mysql is not starting. So, how can we install mysql on other partition and which configuration file we have to do all the changes.

View 1 Replies


ADVERTISEMENT

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error

[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.

[code]....

i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.

View 9 Replies View Related

General :: Install MySQL On Pc?

Mar 6, 2010

I am using ubuntu 9.04. is it possible to install MySQL on my pc??How?? if not what are other possible database system softwares i can use???

View 1 Replies View Related

General :: How To Install Mysql-bench

Feb 8, 2010

I wanted to benchmark my mysql database.
So i want to install mysql-bench.. but i don't know how. code...

View 3 Replies View Related

General :: Install Mysql In Puppy?

Jun 26, 2011

I want to know how to install MYSQL on puppy linux.I searched, but could not find any useful stuff.I found this tutorial useful and want to know is this work on puppy linux[URL]

View 2 Replies View Related

General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?

Aug 7, 2010

How do I create a new mysql user and a mysql database at the shell prompt?

View 1 Replies View Related

General :: Mysql Not Starting After Changing Mysql Admin Password In Fedora?

Feb 19, 2010

Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.

View 1 Replies View Related

General :: Access Remote Mysql Db With Mysql-administrator Command?

May 13, 2011

I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.

now a these days i am connect through ssh and excuting below command

#mytop mysql -u root -p <passwd>

In my mysql db i have added the userip & passwd (allowed the privileages for that ip)

If i use mysql-administrator i am getting below error

MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)

View 6 Replies View Related

General :: Interact With The Mysql To Reset The Root Mysql Pass?

Jun 14, 2011

I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now

Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt

[Code]...

View 6 Replies View Related

General :: Non-Root Portable Install Of MySQL Server?

Mar 3, 2010

Is there a non-root, portable distribution of MySQL for Linux? I need to do some testing on a server that I do not have root access to.

View 2 Replies View Related

General :: Install MySQL Server On Debian While Offline?

Aug 29, 2011

I'm a Linux newbie. I want to install mysql-5.5.15-linux2.6-x86_64.tar.gz on a Debian box offline without using the apt command. How can I do this?

View 1 Replies View Related

General :: Install Mysql Query Browser In Debian?

Mar 17, 2011

I want to install mysql query browser in debian

View 1 Replies View Related

General :: Install And Run Php, Mysql & Apache In Rhel6 In 64bits Redhat

Aug 3, 2011

how to install and run php, mysql & apache in rhel6 in 64bits redhat

View 2 Replies View Related

General :: Not Possible To Install Httpd Mysql Via Rpmforge Repository Of RHEL5

Dec 19, 2010

I wish to install httpd and mysql server softwares via YUM and i added rpmforge rpm, which installed the following content in my /etc/yum.repos.d/rpmforge.repo.....But, when i did a yum clean all and yum install httpd, it is not working.What should I do to get the RHEL5 packages from mirror sites such as rpmforge or epel5 without registering with RHN?

View 5 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

OpenSUSE Install :: MySQL Socket Change For 11.2 / Get The Socket To /var/run/mysql?

May 25, 2010

In looking at the release notes, I saw the comment File locations changes:

* MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location /var/run/mysql by default.

* MySQL log files are in /var/log/mysql. Not sure what I was supposed to do with that information. So I ignored it. Now, I am finding some issues with it. The web server works, but any connection to the database fails with 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)The thought dawned on me that maybe all my databases were erased and none set up. Going in to the terminal, I could connect and list and query the databases. So even though I backed them up, they still are there!

phpMyAdmin gives the same error message.

However, when I go into MySQL Administrator, it works fine.

I forgot where I saw it, but the socket is still set to var/lib/mysql. I could not find any mysql install log and would say what was in my cnf.my, but it still doesn't exist just as it has not in the past. Not sure if I should allow the MySQL Administrator to create it since I always ignored the prompt in the past and it worked. (Just wishing to keep the defaults)

At first I thought the upgrade upgraded the MySQL, but it's still 5.1.39 as I believe before. I've un-installed mysql-server and re-installed it with no change.

Can anyone can tell me how to get the socket to /var/run/mysql or what else is wrong? I read one place where mysql is supposed to set it up.

View 9 Replies View Related

Programming :: Can't Install The DBD:mysql

Jan 22, 2011

May you please some one tel me why I cant install DBD::mysql?I reinstall perl and DBI several times

Perl V5.12 / OS:REDHat Enterprise 5.5

Code:

[root@testsrv5 sh]# cd DBD-mysql-4.018
[root@testsrv5 DBD-mysql-4.018]# ls
ChangeLog dbdimp.h lib MANIFEST myld t
constants.h eg Makefile.PL MANIFEST.SKIP mysql.xs TODO

[code]....

View 4 Replies View Related

CentOS 5 :: Cant Install Mysql On Vps

Jun 26, 2009

i cant install mysql on my vps.

View 6 Replies View Related

CentOS 5 :: Can't Get Mysql To Install And Run

Jul 13, 2009

I used yum to install mysql server and it won't work.

Here is yum install.

yum install php-mysql mysql mysql-server
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* epel: mirrors.tummy.com

[Code].....

View 11 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.

View 1 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.

Code:

View 4 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).

Error I receive is:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 6 Replies View Related

Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?

Jan 14, 2011

i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :

Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing

[code]....

View 4 Replies View Related

Slackware :: Postfix - Cyrus SASL Authentication - Pam-mysql - Mysql Database

May 10, 2011

Pam-mysql can not connect to the database and below are my configurations.

saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH

-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0

-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)

-- active SMTP AUTH and TLS parameters for smtpd --

-- listing of /usr/lib64/sasl2 --

-- listing of /usr/local/lib/sasl2 --

-- content of /usr/lib64/sasl2/smtpd.conf --

-- content of /usr/local/lib/sasl2/smtpd.conf --

-- active services in /etc/postfix/master.cf --

-- mechanisms on localhost --

View 3 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.

Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.

Howver, just been trying to again to fix the problems with downgrading mysql and get:-

Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14

View 7 Replies View Related

Fedora Installation :: Database Conversion From Mysql 4.1.22 To Mysql 5 For A Client?

Apr 2, 2009

I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.

View 4 Replies View Related

Fedora :: Mysql Error When Type Mysql Into The Command Line?

Jan 16, 2011

I have mysql downloaded and when I type mysql into the command line I get this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

View 6 Replies View Related

Ubuntu :: Mysql 5.5.6-rc Error During 'make' Part Of Compilation Of Mysql V5.5.6rc?

Sep 26, 2010

getting foll error during 'make' part of compilation of mysql v5.5.6rc

Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....

View 9 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run

Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:

[code]...

View 13 Replies View Related

Software :: ERROR: Unable To Find Mysql Headers (mysql.h)

Apr 3, 2010

I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:

ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include

[Code].....

I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?

Is it possible to install snort from repositories using yum?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved