Ubuntu Installation :: Restart Mysql And Test The New Location It Said Mysqld.sock Was Missing
Jul 8, 2010
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
View 2 Replies
ADVERTISEMENT
Apr 18, 2011
installing mysql server manually. i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 5 Replies
View Related
Apr 10, 2010
After the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:
Code: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Can anyone point me in the right direction to getting this resolved?
View 2 Replies
View Related
Feb 27, 2011
I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:
Code:
root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock
[code].....
View 4 Replies
View Related
Feb 24, 2011
I need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql
bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
View 1 Replies
View Related
Apr 18, 2011
i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 4 Replies
View Related
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
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
Mar 15, 2010
I am trying to install mysql 5.1.44..so i downloaded the binary package, i extracted it and then followed the instructions that were in the manual but i keep getting this error when running this command
Code:
scripts/mysql_install_db --basedir=/home/mosty/mysql
the error is
Code:
Installing MySQL system tables...
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
100315 20:07:27 [Warning] Can't create test file /var/lib/mysql/mosty.lower-test
[code]....
You can try to start the mysqld daemon with:
shell> /home/mosty/mysql/bin/mysqld --skip-grant &
and use the command line tool /home/mosty/mysql/bin/mysql to connect to the mysql database and look at the grant tables:
shell> /home/mosty/mysql/bin/mysql -u root mysql
mysql> show tables
View 1 Replies
View Related
Feb 5, 2009
I thought that the problem is in the phpMyAdmin not in the mysql. But now i think different. It seems that the problem is right in the mysql. I think that there was no root user, when mysql was freshly installed. Unfortunately i did everything i can find on internet (some tutorials) but they don`t helped me at all, maybe i fu**ed up the mysql service. So i reinstalled it, and when i want to start it there is no file mysql.sock and i get the following:
linux-nepg:~ # service mysql restart
Restarting service MySQL
Shutting down service MySQL done
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
View 9 Replies
View Related
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
May 27, 2011
after I install xampp each time I restart ubuntu mysql.sock is deleted and then I've to remove xampp and install it again and again
the full path is /opt/lampp/var/mysql/mysql.sock
View 1 Replies
View Related
Apr 26, 2010
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
View 9 Replies
View Related
Feb 15, 2011
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
View 6 Replies
View Related
May 23, 2010
My server is using MySQl mysql-5.0.77-3.el5 on Centos 5.4.When I check mysql log at /var/log/mysqld.log,it displays warning Quote:
100524 11:46:21 mysqld started
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
[code]....
View 7 Replies
View Related
Feb 1, 2009
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 Replies
View Related
Apr 30, 2009
We have been struggling with a problem with the mysql-server package. This might be in the wrong category because our problems are with it on x86_64. Where the problem happens variables that should populate from the my.cnf don't, on other servers, they do, the my.cnf files are identical except for the server-id
The problem occurs on some of our machines but not others. All are using the mysql-server-5.0.45-7.el5.x86_64 The ones that work, when you connect with a client respond with server version 5.0.45-log source distribution The ones that don't work respond with 5.0.45 source distribution
It's unclear what the differences are between the two source versions and how we wind up with two different versions. One thing that might be involved, the mysql package is installed with both the i386 and x86_64
View 1 Replies
View Related
Jul 15, 2010
I installed 10.04, and now i cant get back to windows. I have Ubuntu on one hard drive and windows on the other one. When i try to boot up, unless i go to the boot menu and select the hard drive with Ubuntu on it i get the message boot-mgr is missing, press Ctr - Alt - Del to restart.
View 9 Replies
View Related
May 5, 2011
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
View 6 Replies
View Related
Oct 1, 2009
I tried to dual boot Fedora on a vista system. Now fedora boots as primary and when i try to boot vista i get the message, bootmgr missing control, alt, delete to restart.
View 10 Replies
View Related
May 11, 2011
I would like to delete the MySQL ib_logfile but do not know where the files are located on my machine. I am running the latest version of Ubuntu.
View 1 Replies
View Related
Aug 6, 2010
would this script not work?
Code:
#!/usr/bin/perl
#PERL module
use Mysql;
#CONFIG VARIABLES
[Code].....
I clearly have a lot to learn, but I have done about 10 Google searches trying to find out how to test connectivity b/t mod_perl and mysql.. maybe I'm confused on how this works.
I have this in httpd.conf
Code:
Perlrequire /etc/httpd/conf/perl-startup.pl
PerlWarn On
PerlModule Apache::DBI
I have this in perl-startup.pl
[Code]....
View 4 Replies
View Related
Aug 27, 2010
I want to move the location of MySql data file by setting datadir variable but I cannot find the variable in my.cnf file.
Should I set the variable in my.cnf, or is there any other configuration file beside this one?
View 2 Replies
View Related
Feb 12, 2010
Though I kinda do wish that I could just fully migrate to Fedora (or Linux in general), I still do need Vista for some things (like, until I can get this mess with my tablet and speakers sorted out). However, when I tried to boot into Vista this morning (by selecting "other" in GRUB) it said "BTMNGR is missing. Press Ctrl-Alt-Delete to restart."
Will I have to use the Vista Home Premium installation disc to fix this? Surely, telling it to automatically fix startup problems would work, right? I'll try later today PS This problem could also be related to my other 'yum update' problems. All of my problems started when I performed a whole kernel update, so that could also be why I can't boot into vista.
View 9 Replies
View Related
Feb 8, 2010
mysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
View 1 Replies
View Related
Aug 23, 2011
I use dual boot with windos 7. i use xampp in win7. want to use lampp for ubuntu 10.04. i want to use one local server directoy for both . i successfuly changed htdocs location in lampp. but could not change mysql data directory location.
View 4 Replies
View Related
Sep 29, 2010
I know very little about MySQL, but I've got some users that need it for testing on a Linux server.So I had set it up a while back, but now I'm running into some small problems.Right now, each user has his own database that I created and can do whatever with it. Each user only sees their own database.I didn't want them to be able to create new databases at all, but they can and when they do anyone can see them.
EDIT(Apparently they can only create databases beginning with the word "test" in the name)
I need to either:
1) Stop them from creating new databases (without affecting their ability to interact with the existing database)
OR
2) Make it so that when they create a database, only they have privileges on it and only they can see it (except mysql root of course).
Anybody know the statement to set these kinds privileges up?
EDIT: pfft... I've a read a bit more and realize that this is an intended part of the installation.
EDIT2
I'd still like to remove the ability to make test databases.
EDIT3:Ok, for reference this is how you prevent users from making and using test databases:
shell> mysql -u root -p
Enter password: (enter root password here)
mysql> DELETE FROM mysql.db WHERE Db LIKE 'test%';
mysql> FLUSH PRIVILEGES;
View 4 Replies
View Related
Feb 9, 2010
I am trying to change the datadir in my.cnf and try to point it to different location where my database are residing.I have the permission to write on this directory.
datadir = /home/glucose/mysql
#datadir = /var/lib/mysql
if I do ls on my database location.Here is the result
root@bilal-laptop:~# ls -la /home/glucose/mysql
total 20512
drwxr-xr-x 7 mysql mysql 4096 2010-02-09 16:30 .
[Code]....
Because of which I am not able to start mysql. I am not able to locate actual log file as well.I looked at few log files they don't seem to tell me anything.But I am not sure which one I should be looking at as there are quite a few related to mysql.
View 3 Replies
View Related
Sep 9, 2010
I downloaded the deb from the Phoronix site, installed it, and found out there were missing dependencies: php5-cli php5-gd.
These took up about 10.5 MB. Next I ran 'phoronix-test-suite list-tests', agreed to the license, then ran it with 'gui', and found out that I needed to load the 'PHP GTK' module. There is no Debian package ( at least no combination of gtk and php in description or name returned any results ), so I downloaded the source and read the instructions in INSTALL.
When running buildconf, it died due to 'phpize' not being found. This binary only comes with the php5-dev package, another 12 MB. After installing that package, buildconf dies with
Configuring for:
View 1 Replies
View Related
Jul 1, 2010
I just installed 10.04 on a computer I put together, I noticed the button that allows you to switch back and forth to the 'text entry mode' on the nautilus location bar is missing. Is there a way to get this back? I found you can use CTRL+L or use gconf-editor to switch but I used that button quite a bit and want to find a way to get it back.
View 4 Replies
View Related
