View Full Version : [SOLVED] LAMP Issues Persist...
throese
August 25th, 2010, 07:54 AM
Okay, I've tried everything.
Ubuntu Software Center
Synaptic Package Manager
Terminal by installing everything individually
Terminal by using the "sudo tasksel lamp-server" (did that just now)
But even with all of that I DON'T know how to configure the MySQL and PHPMyAdmin stuff.
Does anyone have any idea as to what to do or how I can fix my problems? I can't log into PHPMyAdmin, and idk what to do about MySQL at all.
I'm teaching myself web development, I know plenty about HTML (certified), XHTML, CSS, and a little bit of JavaScript. Working on PHP and MySQL, but I can't do that without the proper tools and if said tools don't work. I can get it all to work on my Windows 7 partition just fine, but here's the thing, I want to COMPLETELY transition over to Ubuntu and obliterate Windows 7 from my hard drive entirely. Will someone please help me so I don't have to deal with Windows anymore, please?
I absolutely love Ubuntu and everything it stands for. I want to be able to help the community and fix bugs etc. etc., but I need more experience. I hope that after a few more months I'll be able to help others.
Thank you to everyone that helps me! =D
theDaveTheRave
August 25th, 2010, 12:16 PM
throese,
first off lets see if there is a mysql server running on your system.
ps aux | grep mysql
with luck you'll have a report of the process that is running.
if not follow this link (http://dev.mysql.com/doc/refman/5.0/en/installing.html) to the installation pages of the manual.
I used this when I have installed MySQL on various systems.
Also you need to have the correct modules turned on on the Apache web server for the php-mysql communication to work.
But we should get to that after you have success on the mysql side.
Also, if mysql isn't running, to check to confirm your version
mysql --version
and then if still nothing, try to start the process
sudo /etc/init.d/mysql start
although on some systems you need
sudo /etc/rc.d/init.d/mysql start
If either one of these fails to work (no such file / directory errors), you may need to change the location of the target?
I am assuming that the 'rc.d' is a determiner for the run level that the service is run as.
I don't believe that ubuntu has an rc.d directory, but this signifies the 'top run level' without which nothing else will work.
I will admit to installing from source so my setup may be a bit 'different' to an install via synaptic or similar.
write back if any of the above has helped, and with any error messages.
David
ps here is a quick link to the debian page regarding run levels.
http://www.debianadmin.com/debian-and-ubuntu-linux-run-levels.html
If you have the process going with
sudo /etc/init.d/mysql start
you will need to add the script into the default run levels (it is run a root).
so if the above has worked the command
sudo update rc.d mysql default
should put the script to start automatically.
throese
August 25th, 2010, 10:06 PM
I did the
ps aux | grep mysql command and I got this:
http://i33.tinypic.com/zlvgj.png
What does it mean and what steps do I take now?
Thanks, theDaveTheRave
theDaveTheRave
August 26th, 2010, 02:57 PM
I did the
ps aux | grep mysql command and I got this:
http://i33.tinypic.com/zlvgj.png
That result suggests that mysql is running, oddly I would have expected to see 3 lines of info, for clarity here is the result of my output
ps aux|grep mysql
root 2925 0.0 0.0 1876 460 ? S 11:25 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 2967 0.0 0.5 131748 2832 ? Sl 11:25 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3307 --socket=/var/run/mysqld/mysqld.sock
davem 23586 0.0 0.1 3344 796 pts/0 R+ 15:41 0:00 grep mysql
If you did the command after a re-boot, you will know that the service start running during boot, which is good.
Your next step is to 'secure' your mysql server.
This link is for 'post instalation (http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html)' which will give full details, follow it through step by step.
Remember to check your version of MySQL,
mysql --versionas the documentation may be slightly different, the page I linked to has the docs for the other version on the left hand side, select yours and then use the menu on the right to find the page you need (should be section 2.18 or there abouts).
For getting php and perl to work with webpages, you need to have your Apache directives set correctly in the httpd.conf file. That however should be for another thread, have a search around the forums, I'll sure you'll find something. If not start a new thread and I'll help you out on that as well.
For now though lets concentrate on getting your mysql server running, and configured securely etc.
Hope that is good for you.
David
throese
August 28th, 2010, 05:35 AM
Thanks, but I have a new problem: http://ubuntuforums.org/showthread.php?t=1562575 =(
theDaveTheRave
August 28th, 2010, 02:48 PM
put an answer on your other thread... briefly.
install the ubuntu-desktop (gnome) or another.
search for backup utilities / use a cron job.
make a separate /home partition to retain the info from one install to the next.
David
throese
August 29th, 2010, 06:23 AM
It's alright. Once I get my old desktop back, I'll wipe all Windows stuff from it and install Ubuntu Server Edition onto it and use it as my web server (offline) for local use like anyone (who uses Windows) would do with WAMP, if that makes sense
Powered by vBulletin® Version 4.2.2 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.