MySQL [Linux] Configure Phpmyadmin under Ubuntu 9.10

[Melzon]

Hello, i will explain how to configure/install phpmyadmin under Ubuntu 9.10

Step 1: Install packets

sudo apt-get install mysql-server (When you compiled the server, you already installed this packet, normally)
sudo apt-get install apache2
sudo apt-get install php5
sudo apt-get install php5-mysql
sudo apt-get install phpmyadmin (Here you configure the passwort for phpmyadmin)

Step 2:
Type this to start Mysql
sudo /etc/init.d/mysql start (Other Options: stop, reload, restart, status)

Step 3:

localhost/phpmyadmin oder 127.0.0.1/phpmyadmin type this into the Browser and login with User: root Passwort: <your passwort>

Step 4:
Create New Database:
Type in the name and go on Create

After that import the schema.mysql file
Click on the SQL Button and import the file

Step 5:
Type into the terminal

sudo gedit config.lua

to open config.lua and config:

Config.lua Database Configurations:

 sqlType = "mysql"  [COLOR="Navy"]//Sql type[/COLOR]
 sqlHost = "localhost"
 sqlPort = 3306 [COLOR="Navy"]//Port für SQL[/COLOR] 
 sqlUser = "root" [COLOR="Navy"]// Name des Users bei phpmyadmin [/COLOR]
 sqlPass = ""   [COLOR="Navy"]// Passwort[/COLOR] 
 sqlDatabase = "otserver" [COLOR="Navy"]//Name of the Database[/COLOR]
 sqlfile = "schema.mysql" [COLOR="Navy"]//File Name, which you imported into the database[/COLOR]
 sqlKeepAlive = 0
 sqlReadTimeout = 10
 passwordType = "plain"

Step 6:
to start the server type into th terminal:

./theforgottenserver

theforgottenserver iste name of the server

If i have forgot something, just tell me eace:

REP++ please

 

[OZiRY]

I just want to add that I had to do this to get phpmyadmin working:

1. Open up the terminal and copy paste:

sudo gedit /etc/apache2/apache2.conf

2. Scroll down to the end of the conf file and add this line:

Include /etc/phpmyadmin/apache.conf

3. Save and type this into the terminal:

sudo /etc/init.d/apache2 restart

Rep++ if it helped <3

 

[FabianoBN]

I'm trying to install phpMyAdmin on my Dedicated is Ubuntu Server 9.10.
More when I try to access it by ip/phpmyadmin
one page writing sample:
Oops! This link appears to be corrupt.
Can anyone help?

 

[Melzon]

Do you enter in browser ip/phpmyadmin?? :blink:

you must enter 127.0.0.1/phpmyadmin

127.0.0.1 is a Loopback-adress, its your own computer or you can just enter localhost/phpmyadmin, its the same

 

[FabianoBN]

just put ip/phpmyadmin
because you can not for the localhost/phpmyadmin or 127.0.0.1/phpmyadmin
Not the descktop that comes with ubuntu browse others use is the server.