-
-
Save codemobiles/522417b242637991ef5a44b96978ac37 to your computer and use it in GitHub Desktop.
Build and install MySQL 5.1 from source on Ubuntu 18.04
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
https://programmersought.com/article/99584829847/ | |
# Crontab | |
@reboot /usr/local/php52/sbin/php-fpm start | |
#!/bin/bash | |
# Run as root | |
yum install make | |
yum install readline-devel | |
yum install ncurses-devel | |
yum install ncurses-compat-libs | |
useradd mysql | |
cd /opt | |
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.73.tar.gz | |
tar xzvf mysql-5.1.73.tar.gz | |
cd mysql-5.1.73 | |
./configure \ | |
'--prefix=/usr' \ | |
'--exec-prefix=/usr' \ | |
'--libexecdir=/usr/sbin' \ | |
'--datadir=/usr/share' \ | |
'--localstatedir=/var/lib/mysql' \ | |
'--includedir=/usr/include' \ | |
'--infodir=/usr/share/info' \ | |
'--mandir=/usr/share/man' \ | |
'--with-system-type=debian-linux-gnu' \ | |
'--enable-shared' \ | |
'--enable-static' \ | |
'--enable-thread-safe-client' \ | |
'--enable-assembler' \ | |
'--enable-local-infile' \ | |
'--with-fast-mutexes' \ | |
'--with-big-tables' \ | |
'--with-unix-socket-path=/var/run/mysqld/mysqld.sock' \ | |
'--with-mysqld-user=mysql' \ | |
'--with-libwrap' \ | |
'--with-readline' \ | |
'--with-ssl' \ | |
'--without-docs' \ | |
'--with-extra-charsets=all' \ | |
'--with-plugins=max' \ | |
'--with-embedded-server' \ | |
'--with-embedded-privilege-control' \ | |
CXXFLAGS="-Wno-narrowing -fpermissive" | |
make | |
make install | |
mkdir -p /etc/mysql | |
mkdir -p /var/lib/mysql | |
mkdir -p /etc/mysql/conf.d | |
echo -e '[mysqld_safe]\nsyslog' > /etc/mysql/conf.d/mysqld_safe_syslog.cnf | |
cp /usr/share/mysql/my-medium.cnf /etc/mysql/my.cnf | |
sed -i 's#.*datadir.*#datadir = /var/lib/mysql#g' /etc/mysql/my.cnf | |
chown mysql:mysql -R /var/lib/mysql | |
mysql_install_db --user=mysql | |
mysqld_safe -user=mysql & | |
/usr/bin/mysql_secure_installation | |
cp /usr/share/mysql/mysql.server /etc/init.d/mysql | |
chmod +x /etc/init.d/mysql | |
chkconfig mysql on | |
# For Vhost | |
NameVirtualHost 150.95.30.195:80 | |
<VirtualHost 150.95.30.195:80> | |
ServerAdmin admin@codemobilse.com | |
ServerName localhost | |
#ServerAlias www.codemobiles.com | |
DocumentRoot /var/www/html/codemobiles.com/public_html/ | |
<Directory "/var/www/html/codemobiles.com/public_html/"> | |
DirectoryIndex index.php index.html index.htm | |
AllowOverride All | |
Options All | |
RewriteEngine on | |
RewriteBase / | |
Order allow,deny | |
Allow from all | |
Require all granted | |
</Directory> | |
ErrorLog /var/www/html/codemobiles.com/logs/error.log | |
CustomLog /var/www/html/codemobiles.com/logs/access.log combined | |
# In case for PHP-FPM 5.2 compatibility use 'GENERIC' instead of 'FPM' | |
# https://httpd.apache.org/docs/2.4/mod/mod_proxy_fcgi.html#proxyfcgibackendtype | |
ProxyFCGIBackendType GENERIC | |
# PHP-FPM Definition | |
<FilesMatch \.php$> | |
Require all granted | |
SetHandler proxy:fcgi://localhost:9000# | |
</FilesMatch> | |
<Proxy "fcgi://localhost:9000/"> | |
ProxySet timeout=180 | |
ProxySet connectiontimeout=180 | |
</Proxy> | |
# If the php file doesn't exist, disable the proxy handler. | |
# This will allow .htaccess rewrite rules to work and | |
# the client will see the default 404 page of Apache | |
RewriteCond %{REQUEST_FILENAME} \.php$ | |
RewriteCond %{DOCUMENT_ROOT}/%{REQUEST_URI} !-f | |
RewriteRule (.*) - [H=text/html] | |
</VirtualHost> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment