Ubuntu Installation :: Setting Up MySql Server (which Is No Server) For Local Use Only

Apr 20, 2010

I like to run a mySql database server on a Ubuntu (which is no server) for local use only. Is there some instruction how to do this? I downloaded several DBMS but they all seem to assume a running server.

View 1 Replies


ADVERTISEMENT

General :: Setting Up Local Server For Php / Mysql

Feb 28, 2010

I've been doing XHTML/CSS for the past several weeks, and started learning PHP last week (all on windows). Learned how to set up IIS server, mysql and php to be able to do all the work locally. Now, I've got Ubuntu 9.04 on my laptop and want to continue working with the book I have on it, so I can do some of the work when I'm away from home as well. Questions I have are:

1. How to set a server up?
2. SQL? (mysql?)
3. php? How do I check if I already have any of those installed on my system, and if not how to set them up?
4. where would the root system be for the server if I have it, or if not, where will it be?
5. do I refer to it as "localhost" here aswell i.e. [URL]

View 3 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

Ubuntu Installation :: Cannot Start Mysql - "Can't Connect To Local MySQL Server Through Socket:"?

Mar 15, 2010

I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':

Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to

[code]....

View 1 Replies View Related

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

Ubuntu Installation :: Cannot Connect To Local MySQL Server Through Socket

Apr 2, 2010

When I type mysql,
vignesh@vignesh:~$ mysql

I get this error.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

So, I checked whether the file mysqld.sock is there in its respective folder, but I could not find that file. How to create the file and start mysql server.

View 1 Replies View Related

CentOS 5 Server :: Setting Up The Local Installation Mirror?

Jan 11, 2010

I've just set up the local mirror for my 96 CentOS 5 workstations. The mirroring script is taken from public-mirror howto and looks like this:

#!/bin/sh
rsync="/usr/bin/rsync -avHzL --delete --delay-updates" # replaced -q with -v for debuging purposes, removed --bwlimit, added -L to follow symlinks
mirror=centos.politechnika.lublin.pl::CentOS # tried several different same result

[Code]....

I tested mirror consistency by putting the mirror addres I'm syncing with, directly into repo file. Than yumex works fine. I tried several different mirrors with the same result.

View 3 Replies View Related

Server :: ERROR 2002 (HY0000): Can't Connect To Local MySQL Server Through Socket

Mar 28, 2010

Im getting this error when i try to run mysql from a shell

Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket

I have installed MySQL over yum on fedora.

but the path and file /var/lib/mysql/mysql.sock does not exist on my system?

View 3 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket

Apr 11, 2010

I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get

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

None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:

Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server

[code].....

View 3 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysq

Apr 24, 2011

I have an e-mail production server that has been running fine for almost two years.

Notice mail was not serving today and login to a bunch of errors in messages

However, I think they are all from not being able to access MySQL and when I:

mysql -u root -p

I get:

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

View 5 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

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

Server :: Setting Up Local Server Using Localhost?

Mar 18, 2010

I have a need to set up the program TNG - The Next Generation of Genealogy Sitebuilding and run it on a local server (not on the Internet) for the purpose of learning the system prior to developing it on an actual website. I was told to use http://localhost on my browser (Mozilla Firefox). I get a message saying "That Works!", but it goes on to say that the contents of the web server have not yet been entered. The instructions for the downloaded files (which I unzipped) said to copy to the web root folder (the folder where the web server is located ?, I guess). But I don't know where it is or how to go about it. Can someone help? I already have MySQL and PHP, which are required to run this program, and I also have Apache installed on my Kubuntu 9.10 system.

View 1 Replies View Related

Server :: Setting Up Local DNS Server

Nov 2, 2009

Further to my previous post, I've been setting up a local web development server using Ubuntu Server 9.10. Thanks to another contributor to this forum, it's now all working.I've installed all of the module necessary (I think) to enable it to act as a DNS server. What I would like to do now is set up a DNS zone inside my network, so that I can go to http://servername instead of http://localhost.I would also like to set it up so that I can have http://servername/www.sitename.com/ and have www.sitename.com as the site root. I've previously achieved something similar using Vhosts on my old setup (which used XAMPP on my local machine). I presumed I could use DNS instead once I'd set up my local webserver.Please bear with me if I'm not referring to things correctly - I'm a web developer who is only just learning about web server management.

View 3 Replies View Related

Server :: Can't Connect To Local MySql Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

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

Server :: Setting On DNS On Local Network

Nov 6, 2009

I am trying to setup my home server for test purposes. Now the IP I have assised my home server are
192.168.1.2
192.168.1.3

Port 80 is open in my firewall and Selinux is off at the moment.Now I have my DNS at my registar pointing at my home IP. Will that work? I have my name server configured with my local ip. Should I use my externel?

View 3 Replies View Related

Ubuntu :: Can't Connect To Local MySQL Server Through Socket / Make It Possible?

May 23, 2010

I'm pretty new to Linux and this is my first post here.

Whenever I try to connect to MySQL, I get the following message:

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

It worked just fine the other day, then are I ran some updates and setup port forwarding to this computer [Ubuntu Server 10.04 LTS].

View 1 Replies View Related

Red Hat / Fedora :: Can't Connect To Local MySQL Server Through Socket

Jul 4, 2010

I'm using fedora 13(x86_64).i got an error message while starting the mysql database software through the kernel. Code: [pradeep@localhost ~]$ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [pradeep@localhost ~]$ this is the first time i'm using the mysql in linux environment. do i have to configure anything before using it for the first time ?!

View 5 Replies View Related

General :: Can't Connect To Local Mysql Server Through Socket?

Aug 8, 2011

i am new member for this forum, i am doing copy data from virtualbox A centos machine to virtualbox B centos machine.first step i use mysqldump database xxx > xxx.sqlthan send to B machine by scp xxx.sql @B machine IP /root.but come to third step, the xxx.sql need import to B machine mysql database,the error occur again:# can't connect to local mysql server through socket 'opt/lampp/lampp/mysql/mysql.socki really dun know how to solve it, use almost 3 hour cannot do solve it,but i use win scp check the folder, i found mysql.sock is no at the /opt/lampp/lampp/mysql/mysql.sock but at/opt/lampp/var/mysql/mysql.socpi dun know how to continue it, i hope those centos user help me to overcomethe issue. thank you very much!centos version 5.5, xampp version 1.4

View 3 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket

Jun 18, 2010

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

following my.cnf setting why this error is coming

#BEGIN CONFIG INFO
#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries
#TYPE: SYSTEM
#END CONFIG INFO

[Code].....

View 8 Replies View Related

Software :: Cannot Connect To Local MySQL Server Through Socket

Apr 26, 2010

I some how installed mysql-5.1.46 (I believe I have installed) When I start mysql I am getting error:
[root@501 ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Then when I restart:
[root@501 ~]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

Then I tried to safe start mysql :
[root@501 ~]# mysqld_safe
100426 21:36:49 mysqld_safe Logging to '/usr/local/mysql/data/501.training.com.err'.
100426 21:36:49 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
100426 21:36:49 mysqld_safe mysqld from pid file /usr/local/mysql/data/501.training.com.pid ended .....

View 2 Replies View Related

Red Hat :: Error 'Can't Connect To Local MySQL Server Through Socket'

Feb 28, 2011

when i tried the command mysql -u root it is giving me an error that "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)" although my mysql server is ruuning beacuse i m using XAMMP server and its inbuild mysql server is running i cannot use service mysqld start command beacuse this command try to start another instance of mysql and i required mysql of XAMMP.

View 3 Replies View Related

CentOS 5 :: Cannot Connect To Local MySQL Server Through Socket

Apr 26, 2010

During the boot of CentOs I see this message which never stops scrolling during all the boot :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

View 3 Replies View Related

Ubuntu :: Setting Up A Local Mail Server - Recall?

Jan 11, 2011

I have a web server that is only accessible to those in the local network. Since it is mainly a testing server, i want to add a test mail server to this system so i can test my programs that email out before i make them public and find out they dont work. I've done this before a while back, but dont recall how i did it or even what the software was(it was for windows, but i want to go linux this time)

View 1 Replies View Related

Server :: CentOS Setting Up Php / Mysql?

Oct 27, 2010

I'm trying to install php / mysql on a remote Centos server.I've completed the installation stages but when I try ' php -v ' it comes up with these errors:

Code:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mcrypt.so' - libltdl.so.3: cannot open shared object file: No such file or directory in Unknown on line 0

[code].....

View 2 Replies View Related

Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language

Sep 29, 2010

I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).

I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file

View 3 Replies View Related

Debian :: Setting Up Local Intranet Server?

Jun 4, 2010

I have been trying to set up an old pIII 700Mhz PC as a local intranet server to run some PHP code.

I have got debian installed setup ssh since it is a headless computer mounted a usb hard drive to store the web page remapped apache2 to use the /mnt/sda1/html/ folder and tested that php scripts are running

now what i can't seem to get working is the following:

ftp access to /mnt/sda1/html so I can upload files from my pc on the network and

phpmyadmin so i can easily manipulat mySQL databases.

after reading [URL] I typed in #apt-get install phpmyadmin

it downloads a bunch of stuff and says it is installing it but when i do the next step in the instructions go to

http://192.168.0.100/phpmyadmin/

I get a 404 Not Found error.

View 3 Replies View Related

Ubuntu Servers :: Use Local Server To Back-up Godaddy Hosted Mysql?

Apr 4, 2010

So, I have a website that is hosted at Godaddy and I've set up a database with the ability to access it remotely. I was wondering if there is an easy way to set up an automated back-up of said database at Godaddy, to my local server.

View 2 Replies View Related

Red Hat / Fedora :: Setting Up A Local Mail Server On 5 Using Sendmail?

Sep 22, 2009

i have fedora5 installed on my machine MACH1, which acts as a linux server for few machines. Its over network and we have a dedicated mail server too which is globally accessible. I wanted to set up a local mail server on MACH1, so that i shall be able to send/receive mails from all the users as well as to our other global mail server(on internet).

View 3 Replies View Related

Ubuntu Servers :: Setting Up Office With 1 Server / 1 Remote / 1 Local Client

Sep 22, 2010

I have a fast computer in my office and I want the person using the slow computer in the same office to boot up and see the login window (gdm) and log-in from there into the fast computer and be able to use their session on the fast computer the same time I am locally logged in to the fast computer as a different user and session.Is this best done through XDMCP? Where is a good tutorial on how to set this up?

View 9 Replies View Related







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