Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th July 2012, 23:53
Dan Healy Dan Healy is offline
Junior Member
 
Join Date: Jul 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Installing Apache2 with PHP5 and MySQL Support on Ubuntu 12.04

I have followed your tutorial with this title with some success:

2 - Installing MySQL 5 worked as expected.

3 - Installing Apache2 worked but gave an IP address of 127.0.1.1 instead of 192.168.0.100. When I opened 127.0.0.1 in the browser I got "It works!".

4 - Installing PHP5 worked as expected.

5 - Testing PHP5 worked as expected and I was able to show info.php in the browser.

6 - Getting MySQL Support in PHP5 appeared to work. I didn't run apt-cache search php5, I just selected php5-mysqland php5-gd from the list in the tutorial. I then did Apache2 restart.

7 - phpMyAdmin I ran apt-get install phpmyadmin and answered the two questions correctly, but it did not show in /var/www. I couldn't find it, so I tried to install it again and it told me it was already installed.

I am trying to port my application from 10.04 to 12.04. MySQL with 12.04 took my dump.sql and permissions.sql with no apparent problems. When I opened my application in the browser I had to use 127.0.0.1 as the IP address, and not localhost or 192.168.0.100. When I tried to connect to the database my application returned the following message:

Could not connect to the database.
mysql error number: 1045
mysql error: Access denied for user 'LSStudent'@'localhost' (using password: YES)

The host and user entries in the user table from the mysql database are below:

mysql> select host, user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | LSAdmin |
| % | LSAuthor |
| % | LSStudent |
| 127.0.0.1 | root |
| ::1 | root |
| dan-K54C | |
| dan-K54C | root |
| localhost | |
| localhost | debian-sys-maint |
| localhost | root |
+-----------+------------------+

Apparently my users are not associated with any host, so cannot be found. How do I find my users, and how do I find phpmyadmin?

Thanks for reading this. I hope you can help.

Dan H.
Reply With Quote
Sponsored Links
  #2  
Old 12th July 2012, 10:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

You probably use a different MySQL password on the new server, so you need to change it in your application's configuration.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 12th July 2012, 17:59
Dan Healy Dan Healy is offline
Junior Member
 
Join Date: Jul 2012
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Smile My application is working

I appreciate your reply, but with my limited knowledge, I didn't understand what to do. I decided to eliminate anonymous and users with ::1 or % host field. I then re-ran
my permissions.sql script. That seemed to solve the problem. My application is working on localhost.

If Ihave to rebuild my system again I will run your script and, after step 2 - Installing MYSQL 5, I will check the user table in mysql and remove any anonymous users before going to step 3.

Dan H
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing Apache2 With PHP5 And MySQL Support On CentOS 5.5 raymccoy HOWTO-Related Questions 1 22nd February 2011 14:57
Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 10.10 SamTzu HOWTO-Related Questions 5 27th November 2010 21:53
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
Problems installing LAMP - MySQL and PHP5 JosBR Server Operation 5 19th December 2009 21:00
MySQL problem satimis Server Operation 5 25th June 2008 15:41


All times are GMT +2. The time now is 10:19.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.