If you do not already know, PS MySQL is useless! It’s basically a MySQL installation on a VPS where you have control over nothing! The only thing you have is assured memory allocation, which is pretty much useless.
So how? Why not create another VPS and install mysqld on it! Seriously, it’s that simple, with that you get full control of your MySQL server, in a real VPS environment.
Simple steps!
ssh into your VPS
where psXXXXX is your VPS server name, like PS23535 etc.
type the following commands to install mysql server and client
sudo apt-get install mysql-client
All this point, your installation may fail, with errors like:
Can’t exec “/tmp/mysql-server-5.1.config.181101”: Permission denied at /usr/share/perl/5.10/IPC/Open3.pm line 168.
open2: exec of /tmp/mysql-server-5.1.config.181101 configure failed at /usr/share/perl5/Debconf/ConfModule.pm line 59
when you run:
you will see:
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777,nosuid,noexec,nodev)
none on /dev/pts type devpts (gid=5,mode=620)
you need
none on /proc type proc (defaults)
none on /tmp type tmpfs (size=128m,mode=1777)
none on /dev/pts type devpts (gid=5,mode=620)
for your installation to run completely, without error.
Please submit a ticket to DH support, to request for the admin to mount /tmp folder without noexec. However, do note of the potential security issues, you may encounter.
Along with the pins in /etc/apt/preferences, this should allow you to keep it updated into the future. lenny-backports is already configured by DH in /etc/apt/sources.list by default.
Add Note
Verified: If you are on a new VPS, it is quite possible that your /etc/apt/preferences and /etc/apt/sources.list are not update or correctly configured for lenny-backports.
In /etc/apt/sources.list you will need to comment out the following line by adding a “#” in the beginning of the line
COMMENT OUT:
then ADD:
In /etc/apt/preferences
APPEND:
Pin: release a=lenny
Pin-Priority: 500
Package: *
Pin: release a=lenny-backports
Pin-Priority: 200
Package: emacs23
Pin: release a=lenny-backports
Pin-Priority: 900
Package: emacs23-common
Pin: release a=lenny-backports
Pin-Priority: 900
Package: debian-backports-keyring
Pin: release a=lenny-backports
Pin-Priority: 900
if you want to setup for remote access, do the follow:
look for bind-address and change to:
again where psXXXXX is your VPS server name.
then enter your password,
mysql> CREATE USER ‘newusr’@’psXXXXX.dreamhostps.com’ IDENTIFIED BY ‘your_password’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘newusr’@’psXXXXX.dreamhostps.com’ WITH GRANT OPTION;
mysql> CREATE USER ‘newusr’@’%’ IDENTIFIED BY ‘your_password’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘newusr’@’%’ WITH GRANT OPTION;
your mysql database user with username ‘newusr’ can now connect from any remote host, since using wildcard “%”.
just change “%” to a specified hostname if you are having a web application connecting to this database from say dreamhost shared hosting, with “%.dreamhost.com” or “%.dreamhostps.com”
alright! written in a bit of a rush cause i wasted many hours trying to install with much complicated methods! gosh*