Installing PHP, MySQL

What you will need, A system running SUSE Linux 10.3 and a fully working and loaded APACHE.

1) Click on Start, Computer, Administrator Settings, This is known as YaST and will be referred to as YaST from here on.

2) Enter your root users password and click on OK

3) Once YaST opens, Click on the SYSTEM icon from the left hand menu. Then on the right hand side click on SYSTEM SERVICES (Run Level Editor)

4) Click on Expert Mode from the top of the YaST window.

5) Scroll down until you see APACHE2, click on it once to select it.

6) Click on the SET / RESET drop down box choose “Enable the Service”

7) Click on set START / STOP / REFRESH drop down box select “Start Now”

8) The APACHE service should have started with no errors, click OK, then Finish and save the changes.

9) You can now close YaST and any other open windows or programs.

=========================================================================

Testing PHP is installed

1) Click on the START menu, then applications, then utilities, then editor and choose advanced text editor (KATE)

2) You may get a message about which session to use, tick the box to “always use this” and choose OPEN SESSION

3) Type the following exactly as it appears in red <?php phpinfo(); ?>

4) Clcik on FILE, and choose save as.

5) On the left hand side of the save as window you will see an icon for public_html, click on it.

6) Now in the location text bar type the name of the file we are saving as info.php and choose OK to save.

7) In the bottom left tool bar you will see a shortcut to Konqueror (a blue and white globe) Click on it to launch the Konqueror browser.

8) In the location address bar at the top type the following address http://localhost/~yourusername/info.php You will need to change yoourusername to the actual username  you are using on the linux PC. 

If you are at all unsure, just click on the start menu and it will tell you the current user! The ~ is important and needed though. (Usually obtained by pressing SHIFT and the key immediately left of the  1 key)

9) You will see a page load up detailing information about PHP. Congratulations!

=========================================================================

Installing MySQL

1) Click on Start, Leave, Switch User and log in as root. If asked, choose start new session.

2) In the bottom left toolbar you will see an icon of a black monitor, this is the terminal window, click on it.

3) type cd /bin and hit ENTER

4) type mysql_install_db –user=mysql (type it exactly as it appears)

5) Open YaST

6) Click on Security and users in the left hand panel

7) Click on Group Management in the right panel

8) Click Add from the bottom of the window.

9) Type MYSQL in the Group Name field (use capitals)

10) Check the boxes next to daemon, mysql and root in the members of this group window

11) Accept and click Finish

12) Close any open windows and programs

13) Open Konqueror and browse to /var/lib/

14) Right click on the /mysql/ directory

15) Choose properties, then permissions

16) Under Access Permissions, select Can View & Modify Content from the GROUP drop down menu
(By default only the OWNER drop down menu is set to this)

17) under the ownership type change the GROUP owner to MYSQL (in caps)

18) There is a CHECK BOX to apply changes to all sub folders and their contents, CHECK this BOX

19) Now click on OK and close any open windows.

20) Log out of root. (Start, Leave, logout)

21) Once logged out of root, your normal user account should be active again, but probably on screensaver, if not log back in.

=========================================================================
Starting the MySQL Service

1) Open YaST

2) Click on the System icon from the left hand side, and choose the System Management (Run Level Editor)

3) Click Expert Mode

4) Click to highlight mysql from the list

5) Under Set / Reset, choose Enable the Service

6) Under the Start / Stop / refresh option, select START NOW

7) MySQL service should now start.

8) Click OK, Finish and Save Changes.

9) NOW REBOOT, Start, Leave, Restart.

=========================================================================

Testing MySQL

1) Open Konqueror

2) and navigate to http://localhost/phpMyAdmin/

3) Choose all cookies from this domain and choose accept

4) You will now have the web page where you can control your MySQL installation from up and running, but right at the bottom of the page it will be highlighted in RED that there is 1 error, relating to no user password.

5) Open START, Applications, System, Terminal in Super User Mode

6) Type your root password, and hit ENTER

7) Type mysqladmin -u root password 'yourpassword'   yourpassword should be different from your user and root password, but must be entered within the '   '

8) Login as ROOT (START, Leave, New Session)

9) Open Konqueror and browse to /srv/www/htdocs/myphpadmin/

10) Right click on the following file config.sample.inc.php and choose rename

11) Remove the .sample from the filename, so it now reads, config.inc.php

12) Right click on the file again, but now choose open with, utilities, editor, KATE

13) Find the line $cfg ['blowfish_secret'] = ' ' and insert a password in between the ' '
eg. $cfg ['blowfish_secret'] = 'mynewpass'

Change nothing else in the file, just add your blowfish password and SAVE

14) Log out of ROOT

=========================================================================

Testing MySQL again, but now with No Error!

1) Log in to your user account.

2) Load Konqueror

3) Goto http://localhost/phpMyAdmin/

 4) Username = root and password = whatever you created earlier for mysql

5) DONE.