V
Vengent
Guest
Mysql5 on Debian Guide
Okay, this is a very rough guide, i'm a tech, not a writer. No guarantees, but it worked for me no problem.
Generic Sarge Install - no desktop, nothing special. Added Plesk.
Installed xinetd
ran psa installer to get
which installed a ton of stuff.
rebooted for good measure
Verified that plesk logs in and works (accept license, admin, default client account, all that jazz.)
installed phpmyadmin in a seperate non plesk directory /var/www/pma, and had it talking to current mysql.
Server version: 4.1.11-Debian_4sarge7-log
So now plesk is installed and ready to upgrade mysql5.
Added the following to sources.list
deb http://autoinstall.plesk.com/debian/PSA_8.1.0 sarge all
deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all
Did an apt-get update
apt-get install mysql-server-5.0
The following extra packages will be installed:
libmysqlclient15off mysql-client-5.0 mysql-common
Suggested packages:
tinyca
The following packages will be REMOVED:
mysql-client-4.1 mysql-common-4.1 mysql-server-4.1
The following NEW packages will be installed:
libmysqlclient15off mysql-client-5.0 mysql-common mysql-server-5.0
Say yes. This will take a few minutes.
Set the password
Answer the account question
configuration file - I kept current
At that point mysqld will restart as 5.
You may or may not need the privilege step, but I ran just in case.
/usr/bin/mysql_fix_privilege_tables
find that file, then run it with your permissions as such
./mysql_fix_privilege_tables --user=admin --password=password
That will import the sql file to make schema changes on the privilege database.
I fired up phpmyadmin
Server version: 5.0.30-Debian_0.dotdeb.1-log
Loaded up the plesk console - no errors. Tried to edit an existing database, all good, tried to create a new database, all good.
Works with both the seperate phpmyadmin, and the built in (and much older) version.
Mysql5 on debian with Plesk 8.1
Good luck with it. I'm going to try php5 next, then will attempt to update it to etch rc3.
Okay, this is a very rough guide, i'm a tech, not a writer. No guarantees, but it worked for me no problem.
Generic Sarge Install - no desktop, nothing special. Added Plesk.
Installed xinetd
ran psa installer to get
which installed a ton of stuff.
rebooted for good measure
Verified that plesk logs in and works (accept license, admin, default client account, all that jazz.)
installed phpmyadmin in a seperate non plesk directory /var/www/pma, and had it talking to current mysql.
Server version: 4.1.11-Debian_4sarge7-log
So now plesk is installed and ready to upgrade mysql5.
Added the following to sources.list
deb http://autoinstall.plesk.com/debian/PSA_8.1.0 sarge all
deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all
Did an apt-get update
apt-get install mysql-server-5.0
The following extra packages will be installed:
libmysqlclient15off mysql-client-5.0 mysql-common
Suggested packages:
tinyca
The following packages will be REMOVED:
mysql-client-4.1 mysql-common-4.1 mysql-server-4.1
The following NEW packages will be installed:
libmysqlclient15off mysql-client-5.0 mysql-common mysql-server-5.0
Say yes. This will take a few minutes.
Set the password
Answer the account question
configuration file - I kept current
At that point mysqld will restart as 5.
You may or may not need the privilege step, but I ran just in case.
/usr/bin/mysql_fix_privilege_tables
find that file, then run it with your permissions as such
./mysql_fix_privilege_tables --user=admin --password=password
That will import the sql file to make schema changes on the privilege database.
I fired up phpmyadmin
Server version: 5.0.30-Debian_0.dotdeb.1-log
Loaded up the plesk console - no errors. Tried to edit an existing database, all good, tried to create a new database, all good.
Works with both the seperate phpmyadmin, and the built in (and much older) version.
Mysql5 on debian with Plesk 8.1
Good luck with it. I'm going to try php5 next, then will attempt to update it to etch rc3.