Ubuntu :: Can't Run MySql Localhost And Apache
Dec 23, 2010
if I should ask this in the server section. But since I use the desktop version of Ubuntu I will ask here. Basically my server is going on pension. Hardware is outdated and all that. Since it's main job was serving me with MySql databases with web interfaces I sommer want to shift all of that over to my desktop and run my databases on the desktop. It's only me that access it so don't see why I can't run it localhost.
My question is. The three main things I need, apache, Mysql and php, are they in the repositories in Synaptec ? If not how hard will the install and config of those three apps be on Ubuntu Desktop? (I've always used Fedora as server with everything build-in so have no experience of installing mysql, apache and php from scratch)
View 2 Replies
ADVERTISEMENT
May 28, 2011
Running MYSQL 5.5.12 and MYSQL Workbench 1:5.2.34 on up-to-date Arch linux Set up MYSQL with root account and password. When running Workbench as user, got error when trying to connect :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Can't connect to MySQL server on '127.0.0.1' (111)
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
After commenting #skip-networking in my.cnf error changed to :
Quote:
Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from
Copying my.cnf to /etc/ and running Workbench as root didn't change anything, i still get the second error The wiki [URl] says to enable MYSQL in /etc/hosts.allow but i didn't do it, i guess it is required only when trying to access MYSQL from remote hosts which i dont.
View 2 Replies
View Related
May 11, 2010
Howcome mysql by default is only allowing connections from localhost? I want to access it remotely from another account (not root).
View 1 Replies
View Related
Apr 21, 2011
iam not able to connect localhost in mysql.i uswd command for mysql is
#mysqladmin -u root -h localhost password "123456"
ErroR:-
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
View 1 Replies
View Related
Apr 17, 2011
I used 4 host to establish a high-availability web server system. 2 Load Balancer + 2 Web Server(installed MySQL Server 5.5). 2 MySQL Server used Multi-Master Replication.Used "Amoeba" as MySQL Proxy which direct the write statement to a specific MySQL Server.I can login Amoeba and MySQL Server using MySQL client. I tried query something in XAMMP on Windows XP. It work!
Installed related software:
MySQL-server-5.5.11-1.rhel5
MySQL-shared-compat-5.5.11-1.rhel5
php53-mysql-5.3.3-1.el5_6.1
MySQL-client-5.5.11-1.rhel5
[code]....
What I tried:
yum install php php-mysql
yum install php53 php53-mysql
Compiled php 5.3.6 soruce + MySQL 5.5 Server, Client, Shared, Shared-Compact Above software installed on different host. And the phpinfo showing MySQL I doubt something wrong in my php.ini. Used default php configuration.
View 5 Replies
View Related
Sep 25, 2009
php can't connect mysql by 'localhost' but can connect by IP address:
[Code]...
View 3 Replies
View Related
Mar 29, 2009
I have installed apache. The problem is that localhost works but not the ip for viewing my hosted sites.
How can i rectify this error?
View 5 Replies
View Related
Nov 28, 2010
I have Apache2 running on my server and can serve up pages on that box, but cannot seem to access them from other PCs on the network.
View 1 Replies
View Related
Jul 5, 2011
I am following this howto to install Apache, MySQL, and PHP5:
[URL]
I have just installed Apache and I am pointing my browser to:
http://192.168.0.100
but I am getting the error message that the server is taking too long to respond.
View 1 Replies
View Related
Jul 11, 2011
I've installed apache2 on ubuntu 10.04 and everything works fine, but when I use functions that needs to connect to Internet, it doesn't work. Is there a simple setup I've forgot? I've been searching and looking for a solution, but I'm stuck!
View 9 Replies
View Related
Mar 14, 2011
I did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
View 2 Replies
View Related
Jun 28, 2011
I have installed VirtualBox on a MacBook and installed RHEL6 on a guest server ("Orion") in VirtualBox. I am trying to follow the tutorial at xenocafe on Apache Web Server Tutorial for Linux. I've checked a few other websites for port forwarding, and have used VBoxManage to set
Apache/GuestPort" 80
Apache/HostPort" 8888
Apache/Protocol" TCP
[code]...
I am able to ssh into the Virtual Box guest server using:
$ ssh -l rmt1 -p 2222 localhost
I believe this means that the port forwarding works. I am able to start and stop httpd on the guest with no warnings. I retired a problem with DocumentRoot by setting SELinus to disabled. My trouble is that: When I bring up a browser on the host and try localhost 8888 and expect to see my sample html page housed on the guest server (located under root / www), what I get is a spinning wheel.
And when I bring up a browser on the guest and try localhost 80 and expect to see the sample page I made, what I get is the well-known Apache test page. I am stuck in knowing (1) how to cause port 80 output from the guest to be interpreted by the host browser searching port 8888 (Or, Why does ssh into the guest work but http out of the guest not work), and, (2) how to arbitrarily determine the location of what the very first webpage is that will be loaded.
View 2 Replies
View Related
Oct 7, 2009
I'm running wordpress and have gone to the painstaking effort of setting up the ftp server on my 5.3 machine so it can do its own updates and download plugins. However, I've found that if I try to download anything, I get a "unable to resolve host..." error from the script. If I watch Iptraf while making the request, I see all the port 53 requests going to 127.0.0.1. Pings are too.
However, if I ssh in, I can ping and wget and whatever I want all day long and all the DNS requests to go the router (Clarkconnect 3.2 gateway machine). The web browser in the terminal works fine too. What is it about the php scripts that is causing them to misdirect pings and dns requests? I've never seen anything like it and can't find anything on the web about it either.
[Code]....
View 2 Replies
View Related
Dec 27, 2010
I have setup a Linux Centos with apache server on it in a home network. Everything works fine. When I access the webserver I put in the address bar the IP address of the server which is 192.168.0.150 and when hit enter, it prompts the page where I have to put login information. The login information is set to: username: admin@localhost.local password: *************
It takes long time for authentication go through and load the page eventhough I am accessing the site in a same home local area network with fast ethernet connection. How can I change the localhost.local to something else like maybe [URL] instead and if I have to change settings in other files as well?
View 5 Replies
View Related
Mar 10, 2010
I have some confusion about mysqladmin and mysql.I am using mysql version Quote:
[root@localhost freepbx-2.7.0]# mysql --version
mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
My MySQL is running
Quote:
[root@localhost freepbx-2.7.0]# /etc/init.d/mysqld status
mysqld (pid 11440) is running...
[Code]...
View 4 Replies
View Related
Jan 19, 2011
I've just upgraded my laptop to Fedora 14 and installed LAMP on it for a test environment. I've followed the official instructions to install but seem to have a problem that I didn't have on F13 or Opensuse. Each time I try to access index.php on localhost I get a permission denied message and an SElinux alert. I have tried 7 different solutions on various forums and just can't view anything in a browser.
/var/www/html has been set to chmod 777
/var/www/html/index.php has also been set to chmod 777
A standard user can definitely read and write to the above files/folder. Until I commented it out the Welcome/Test page was working perfectly.
View 5 Replies
View Related
Mar 26, 2010
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
View 4 Replies
View Related
Nov 9, 2010
I think I screwed up my Administrative username in mysql.
mysql -u root mysql
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
Can I just copy all the files in /var/lib/mysql >>reinstall MySQL >> copy all the old folders into the new /var/lib/mysql ( while MySql is off)
View 9 Replies
View Related
May 31, 2010
I am planning on installing an Apache server today. I know how to get it to point to addresses like "localhost" or my outside ip, but how do I get it to point to a URL like [URL]? (That's just an example URL)
View 4 Replies
View Related
Mar 19, 2010
how i can instal mysql,apache and php through my usb. what commands do i need?
View 2 Replies
View Related
May 9, 2010
My config:
Ubuntu 9.0.4 (all up to date with security patches)
Apache 2.2.11
MySQL version 5.0.75
PHP Version 5.2.6-3ubuntu4.5
I'm running Ubuntu as a Virtual machine with VMWare on top of a Windows 2008 Server. It has been working perfectly for nearly 9 months. I have one processor and 2GB of Ram assigned to the Virtual machine. Memory usage seldom ever reaches more than 50%, swapfile is hardly used either. I noticed recently that sites were loading very slow from time to time. Webmin showed me that USER / KERNEL were together using 100% cpu. I then started searching for answers to what was causing this and then read about using HTOP. I then installed HTOP and found that the following processes were the culprits
/usr/sbin/mysqld
/usr/sbin/apache2 -k start
There are multiple instances of mysqld and apache2 listed in HTOP, I assume this is because I run multiple sites on the box. It does however seem limited to only one or two PID's that are repeatedly maxing out the CPU at 100% (every 30 seconds to a minute) sometimes the CPU will stay maxed at 100% for nearly a minute and then free itself again but it is doing this continually. At the point when the CPU maxes out at 100% there will be one instance of mySQLD and one instance of Apache2 right at the top of HTOP and between the two they will be hogging 100% cpu. All the sites are either Wordpress or Joomla sites and I am quite confident it's one of these sites causing a problem.
My issue is that I cannot pin down which PID belongs to which site. Then, once I know which site it is how do I then trace what process / file inside that site is casuing the problem? I figured one of my busiest sites (wordpress) might be the culprit and I installed the W3 Total Cache plugin today but that has not helped this 100% cpu problem, so for all I know it might be another WP site on the box or even one of the Joomla sites. I've noticed that the TIME column on the one MYSQLD instance that maxes out is very long so it seems like Mysql is keeping some connection open or something?
View 8 Replies
View Related
Feb 1, 2009
I'm dual booting Windows XP and the latest version of Ubuntu.
I am trying to setup VHCS (vhcs.net)
In order to do so, it requires:
* Postfix (Version 2 or greater)
* ProFTPd
* Apache (Version 2 or greater)
* Courier POP3 and IMAP
* Bind9
* MySQL (Version 4 or greater)
* iptables
how to install on Ubuntu. I have done it with Windows XP, but not Ubuntu
View 14 Replies
View Related
Apr 16, 2010
i have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
View 5 Replies
View Related
Apr 21, 2010
how to connect to mysql database using php in Apache on Ubuntu?
View 4 Replies
View Related
Jan 26, 2011
I want to install all the functionality I need to make dynamic webpages. Can I use the Ubuntu Software Center, or will I have to use the cmd line?
View 2 Replies
View Related
Mar 9, 2010
how to integrate apache with mysql
View 2 Replies
View Related
Jul 29, 2010
Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.
View 1 Replies
View Related
Jul 10, 2010
We are working on a new ERP for the company. This will run in MySQL 5.1.x, the GUI will be Web, the language PHP. This is a big project, is a good option to have the 3 applications in the same server or is better to have Mysql on 1 server and httpd+php on other server?
Speaking that I want to virtualize this app with Xen on Centos 5.5 as Host and the guest's will run Ubuntu.
View 3 Replies
View Related
May 4, 2010
I am at work right now and noticed my blog is down because of a database connection error. phpmyadmin wont load either it says theres an error, and webmin wont load either. So what would cause a mysql to go down? a hack or update? i am running ten.o four ubuntu server.
View 3 Replies
View Related
Jul 4, 2010
I have been using wamp on an xp box and now have set up ubuntu with the localhost server seeming to be going okay.
As this is just a desktop graphical test server with no real public hosting, I was hoping to find a control panel like in wamp where one can stop/start php, apache, mysql, phpmyadmin and see logs etc.
View 4 Replies
View Related
