MySQL 5 In Debian Sarge (Stable ) HowTo
Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
|
I needed to run mysql5 on another port on my server
with already 2 mysql servers (3.x and 4.x) on it and for this i had to do following steps wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.22.tar.gz/from/http://gd.tuwien.ac.at/db/mysql/ tar -zxvf mysql-5.0.22.tar.gz cd mysql-5.0.22 sudo ./configure --prefix=/opt/mysql-5.0.22 --localstatedir=/opt/mysql-5.0.22 --with-innodb --without-debug --with-tcp-port=3308 --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql-5.0.22.sock make sudo make install sudo mkdir -p /var/lib/mysql5 sudo chown mysql.mysql /var/lib/mysql5 cd /opt/mysql-5.0.22/bin sudo ./mysql_install_db --datadir=/var/lib/mysql5 --user=mysql go to the source files sudo cp mysql-5.0.22/support-files/mysql.server /etc/init.d/mysql-5.0.22 modify this variable in start-up script datadir=/var/lib/mysql5 sudo vi /etc/init.d/mysql-5.0.1 create in /opt/mysql-5.0.22 my.cnf file with this content $ cat my.cnf [mysqld] user = mysql port = 3308 cd /etc/init.d update-rc.d mysql-5.0.22 defaults PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /opt/mysql-5.0.22/bin/mysqladmin -u root password 'new-password' /opt/mysql-5.0.22/bin/mysqladmin -u root -h example password 'new-password' You can do the same thing from mysql batch processor /opt/mysql-5.0.22/bin/mysql -u root -h SET PASSWORD FOR 'root'@'example' = PASSWORD('******'); See the manual for more instructions. You can start the MySQL daemon with: cd /opt/mysql-5.0.22 ; /opt/mysql-5.0.22/bin/mysqld_safe & or with the init.d script cd /etc/init.d # chmod +x mysql-5.0.22 # update-rc.d mysql-5.0.22 enjoy creating databases :) /opt/mysql-5.0.22/bin/mysql -u root -h localhost.localdomain -P 3308 -p
|
Sponsored Links:
Unified Communications: Thoughts, Strategies and Predictions
Join the discussion.
www.seamlessenterprise.com
IP Convergence
Integrate your wireless and wireline networks.
Learn how from the experts at Sprint.
www.seamlessenterprise.com
Wireless & Wireline Integration
Thoughts, strategies and solutions: join the discussion
www.seamlessenterprise.com
Unified Communications 2009
Join the Discussion. Now.
www.seamlessenterprise.com
Red Hat Virtual Experience - a free virtual event. Dec. 9th
Join the discussion.
www.seamlessenterprise.com
IP Convergence
Integrate your wireless and wireline networks.
Learn how from the experts at Sprint.
www.seamlessenterprise.com
Wireless & Wireline Integration
Thoughts, strategies and solutions: join the discussion
www.seamlessenterprise.com
Unified Communications 2009
Join the Discussion. Now.
www.seamlessenterprise.com
Red Hat Virtual Experience - a free virtual event. Dec. 9th







Recent comments
9 hours 45 min ago
15 hours 34 min ago
17 hours 25 min ago
19 hours 10 min ago
23 hours 42 sec ago
1 day 4 hours ago
1 day 4 hours ago
1 day 9 hours ago
1 day 14 hours ago
1 day 20 hours ago