- MySQL 8.2 from PLD

[packages/mysql.git] / mysql.init

diff --git a/mysql.init b/mysql.init
index 9f0867e23fd32de0f255c90e4665119e56e2c3b9..c0a7a2677aeeb4c9f6608217b5a9b07d19345563 100755 (executable)
--- a/mysql.init
+++ b/mysql.init
@@ -1,6 +1,6 @@
 #!/bin/sh
 #
 #!/bin/sh
 #

-# mysql                A very fast and reliable SQL database engine
+# mysql{MYSQL_MAJOR}           A very fast and reliable SQL database engine

 #
 # chkconfig:   2345 84 25
 #
 #
 # chkconfig:   2345 84 25
 #


@@ -13,30 +13,30 @@
 . /etc/sysconfig/network
 
 # Get service config
 . /etc/sysconfig/network
 
 # Get service config

-if [ -f /etc/sysconfig/mysql ]; then
-       . /etc/sysconfig/mysql
+if [ -f /etc/sysconfig/mysql{MYSQL_MAJOR} ]; then
+       . /etc/sysconfig/mysql{MYSQL_MAJOR}

 else
 else

-       nls "Error: %s not found" /etc/sysconfig/mysql
-       nls "%s can't be run." MySQL
+       nls "Error: %s not found" /etc/sysconfig/mysql{MYSQL_MAJOR}
+       nls "%s can't be run." MySQL{MYSQL_MAJOR}

        exit 1
 fi
 
 if [ -n "$MYSQL_DB_CLUSTERS" ]; then
        exit 1
 fi
 
 if [ -n "$MYSQL_DB_CLUSTERS" ]; then

-       nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql/clusters.conf
+       nls "Warning: MYSQL_DB_CLUSTERS is set. It's obsolete. Use %s instead." /etc/mysql{MYSQL_MAJOR}/clusters.conf

 fi
 
 fi
 

-if [ -f /etc/mysql/clusters.conf ]; then
-       MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/ && /=/{print $2}' /etc/mysql/clusters.conf)
+if [ -f /etc/mysql{MYSQL_MAJOR}/clusters.conf ]; then
+       MYSQL_DB_CLUSTERS=$(awk -F= '!/^#/ && /=/{print $2}' /etc/mysql{MYSQL_MAJOR}/clusters.conf)

        if [ -z "$MYSQL_DB_CLUSTERS" ]; then
                nls "Warning: there are no configured clusters."
        fi
 
 else
        if [ -z "$MYSQL_DB_CLUSTERS" ]; then
                nls "Warning: there are no configured clusters."
        fi
 
 else

-       nls "Warning: Missing clusters config file %s" /etc/mysql/clusters.conf
+       nls "Warning: Missing clusters config file %s" /etc/mysql{MYSQL_MAJOR}/clusters.conf

        if [ -z "$MYSQL_DB_CLUSTERS" ]; then
                nls "Warning: there are no configured clusters."
        if [ -z "$MYSQL_DB_CLUSTERS" ]; then
                nls "Warning: there are no configured clusters."

-               nls "Using default cluster /var/lib/mysql (compatibility mode)"
-               MYSQL_DB_CLUSTERS=/var/lib/mysql
+               nls "Using default cluster /var/lib/mysql{MYSQL_MAJOR} (compatibility mode)"
+               MYSQL_DB_CLUSTERS=/var/lib/mysql{MYSQL_MAJOR}/01

        fi
 fi
 
        fi
 fi
 


@@ -44,14 +44,14 @@ fi
 # Check that networking is up
 if is_yes "${NETWORKING}"; then
        if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then
 # Check that networking is up
 if is_yes "${NETWORKING}"; then
        if [ ! -f /var/lock/subsys/network -a "$1" != stop -a "$1" != status -a "$1" != init ]; then

-               msg_network_down MySQL
+               msg_network_down MySQL{MYSQL_MAJOR}

                exit 1
        fi
 else
        exit 0
 fi
 
                exit 1
        fi
 else
        exit 0
 fi
 

-sharedir=/usr/share/mysql
+sharedir=/usr/share/mysql{MYSQL_MAJOR}

 
 action="$1"
 
 
 action="$1"
 


@@ -60,9 +60,9 @@ if [ $# -gt 1 ]; then
        shift
        # perform action for specified clusters only
        for a in "$@"; do
        shift
        # perform action for specified clusters only
        for a in "$@"; do

-               # try auto resolving from /etc/mysql/clusters.conf
+               # try auto resolving from /etc/mysql{MYSQL_MAJOR}/clusters.conf

                if [[ "$a" != /* ]]; then
                if [[ "$a" != /* ]]; then

-                       m=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $1}' /etc/mysql/clusters.conf)
+                       m=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $1}' /etc/mysql{MYSQL_MAJOR}/clusters.conf)

                        if [ -z "$m" ]; then
                                echo >&2 "Cluster name '$a' did not match anything!"
                                exit 1
                        if [ -z "$m" ]; then
                                echo >&2 "Cluster name '$a' did not match anything!"
                                exit 1


@@ -71,7 +71,7 @@ if [ $# -gt 1 ]; then
                                echo >&2 "Cluster name '$a' ambiguous:" $m
                                exit 1
                        fi
                                echo >&2 "Cluster name '$a' ambiguous:" $m
                                exit 1
                        fi

-                       a=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $2}' /etc/mysql/clusters.conf)
+                       a=$(awk -va="$a" -F= 'substr($0, 1, length(a)) == a {print $2}' /etc/mysql{MYSQL_MAJOR}/clusters.conf)

                fi
                DB_CLUSTERS="$DB_CLUSTERS $a"
        done
                fi
                DB_CLUSTERS="$DB_CLUSTERS $a"
        done


@@ -80,7 +80,7 @@ else
 fi
 
 # global error log, if mysqld.conf hasn't migrated to log-error style
 fi
 
 # global error log, if mysqld.conf hasn't migrated to log-error style

-MYSQL_ERRLOG=/var/log/mysql/mysqld.log
+MYSQL_ERRLOG=/var/log/mysql{MYSQL_MAJOR}/mysqld.log

 MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}
 
 #
 MYSQL_STOP_WAIT_TIME=${MYSQL_STOP_WAIT_TIME:-900}
 
 #


@@ -125,7 +125,7 @@ mysqlstatus() {
        fi
 
        if [ "$mode" = "start" ]; then
        fi
 
        if [ "$mode" = "start" ]; then

-               MYSQL_GREP_PID=$(grep -alE "^/usr/sbin/mysqld.*${MYSQL_PIDFILE}" /proc/[0-9]*/cmdline 2> /dev/null | awk -F "/" '{ print $3; exit; }')
+               MYSQL_GREP_PID=$(grep -alE "^/usr/sbin/mysqld{MYSQL_MAJOR}.*${MYSQL_PIDFILE}" /proc/[0-9]*/cmdline 2> /dev/null | awk -F "/" '{ print $3; exit; }')

                if [ -n "$MYSQL_GREP_PID" ]; then
                        MYSQL_PID=$MYSQL_GREP_PID
                        if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then
                if [ -n "$MYSQL_GREP_PID" ]; then
                        MYSQL_PID=$MYSQL_GREP_PID
                        if grep -qa "$MYSQL_PIDFILE" /proc/$MYSQL_PID/cmdline 2> /dev/null; then


@@ -159,20 +159,14 @@ mysqlgetconfig() {
        local clusterdir="$1" config_file
        local mode="$2"
 
        local clusterdir="$1" config_file
        local mode="$2"
 

-       # emulate old behaviour if only one cluster specified
-       if [ "$clusterdir" = "$MYSQL_DB_CLUSTERS" -a "$clusterdir" = "/var/lib/mysql" -a -f /etc/mysqld.conf ]; then
-               MYSQL_RA_COMPAT=yes
-               config_file=/etc/mysqld.conf
-       else
-               local config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/mysql/clusters.conf)
-               if [[ $config = /* ]]; then
-                       config_file="$config"
-               elif [ -f "/etc/mysql/$config" ]; then
-                       config_file="/etc/mysql/$config"
-               else
-                       config_file="$clusterdir/mysqld.conf"
-               fi
-       fi
+        local config=$(awk -F= -vclusterdir="$clusterdir" '!/^#/{ if (clusterdir == $2) print $1}' /etc/mysql{MYSQL_MAJOR}/clusters.conf)
+        if [[ $config = /* ]]; then
+                config_file="$config"
+        elif [ -f "/etc/mysql{MYSQL_MAJOR}/$config" ]; then
+                config_file="/etc/mysql{MYSQL_MAJOR}/$config"
+        else
+                config_file="$clusterdir/mysqld.conf"
+        fi

 
        MYSQL_CLUSTER_DIR="$clusterdir"
 
 
        MYSQL_CLUSTER_DIR="$clusterdir"
 


@@ -189,7 +183,7 @@ mysqlgetconfig() {
 
        if [ ! -f "$config_file" ]; then
                nls "Error: config file %s not found" "$config_file"
 
        if [ ! -f "$config_file" ]; then
                nls "Error: config file %s not found" "$config_file"

-               nls "MySQL can't be run. Did you initialize DB by doing \`$0 init'?"
+               nls "MySQL{MYSQL_MAJOR} can't be run. Did you initialize DB by doing \`$0 init'?"

                if [ "$mode" = "status" ]; then 
                        exit 3
                else
                if [ "$mode" = "status" ]; then 
                        exit 3
                else


@@ -248,11 +242,7 @@ mysqlgetconfig() {
                unset MYSQL_LOG_ERROR
        fi
 
                unset MYSQL_LOG_ERROR
        fi
 

-       if is_yes "$MYSQL_RA_COMPAT"; then
-               MYSQL_DATA_DIR_SUB=""
-       else
-               MYSQL_DATA_DIR_SUB="/mysqldb"
-       fi
+       MYSQL_DATA_DIR_SUB="/mysqldb"

 
        if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
                nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"
 
        if [ -z "$MYSQL_DATA_DIR" -o "$MYSQL_DATA_DIR" != "${clusterdir}${MYSQL_DATA_DIR_SUB}/db" ]; then
                nls "Error: datadir specified in %s should be %s" "$config_file" "$clusterdir${MYSQL_DATA_DIR_SUB}/db"


@@ -267,7 +257,7 @@ mysqlgetconfig() {
        fi
 
        if [ -z "$MYSQL_USER" ]; then
        fi
 
        if [ -z "$MYSQL_USER" ]; then

-               echo "$(nls 'MySQL user not configured properly')"'!' >&2
+               echo "$(nls 'MySQL{MYSQL_MAJOR} user not configured properly')"'!' >&2

                nls "Edit %s and configure it." "$config_file" >&2
                exit 6
        fi
                nls "Edit %s and configure it." "$config_file" >&2
                exit 6
        fi


@@ -278,23 +268,23 @@ mysqlstart() {
        local clusterdir="$1"
        mysqlgetconfig "$clusterdir"
        if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then
        local clusterdir="$1"
        mysqlgetconfig "$clusterdir"
        if [ ! -d "$MYSQL_DATA_DIR/mysql" ]; then

-               nls "MySQL cluster %s not initialized." "$clusterdir"
+               nls "MySQL{MYSQL_MAJOR} cluster %s not initialized." "$clusterdir"

                nls "Try \`%s init %s' before start." "$0" "$clusterdir"
                exit 6
        fi
 
                nls "Try \`%s init %s' before start." "$0" "$clusterdir"
                exit 6
        fi
 

-       msg_starting "MySQL $clusterdir"; busy
+       msg_starting "MySQL{MYSQL_MAJOR} $clusterdir"; busy

        [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
        rm -f "$MYSQL_PIDFILE"
 
 
        TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \
        [ -z "$DEFAULT_SERVICE_RUN_NICE_LEVEL" ] && DEFAULT_SERVICE_RUN_NICE_LEVEL=0
        rm -f "$MYSQL_PIDFILE"
 
 
        TMPDIR=/tmp nice -n ${SERVICE_RUN_NICE_LEVEL:-$DEFAULT_SERVICE_RUN_NICE_LEVEL} \

-               /usr/bin/setsid /usr/sbin/mysqld \
+               /usr/bin/setsid /usr/sbin/mysqld{MYSQL_MAJOR} \

                        --defaults-file=$MYSQL_CONFIG \
                        --datadir=$MYSQL_DATA_DIR \
                        --pid-file=$MYSQL_PIDFILE \
                        ${MYSQL_LOG_ERROR:+--log-error="$MYSQL_LOG_ERROR"} \
                        --defaults-file=$MYSQL_CONFIG \
                        --datadir=$MYSQL_DATA_DIR \
                        --pid-file=$MYSQL_PIDFILE \
                        ${MYSQL_LOG_ERROR:+--log-error="$MYSQL_LOG_ERROR"} \

-                       $MYSQL_OPTIONS 2>/dev/null &
+                       $MYSQL_OPTIONS &

        pid=$!
 
        sleep 0.1
        pid=$!
 
        sleep 0.1


@@ -302,7 +292,7 @@ mysqlstart() {
        # it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
        if [ "$MYSQL_STATUS" = "starting" ]; then
                echo ""
        # it takes longer for mysqld to start and create pidfile if it has to recover innodb transactions
        if [ "$MYSQL_STATUS" = "starting" ]; then
                echo ""

-               show "Waiting for MySQL to start"
+               show "Waiting for MySQL{MYSQL_MAJOR} to start"

                busy
 
                # while the pid is running, mysql is starting up
                busy
 
                # while the pid is running, mysql is starting up


@@ -336,7 +326,7 @@ mysqlstop() {
 
        # try graceful shutdown -- send shutdown command
        # requires mysql_sysadmin user proper privs
 
        # try graceful shutdown -- send shutdown command
        # requires mysql_sysadmin user proper privs

-       /usr/bin/mysqladmin --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1
+       /usr/bin/mysqladmin{MYSQL_MAJOR} --defaults-file=$MYSQL_CONFIG ${MYSQL_SOCKET:+--socket=$MYSQL_SOCKET} shutdown >/dev/null 2>&1

        mysqlstatus "$clusterdir" stop
 
        if [ "$MYSQL_PID" != "unknown" ]; then
        mysqlstatus "$clusterdir" stop
 
        if [ "$MYSQL_PID" != "unknown" ]; then


@@ -360,13 +350,13 @@ mysqlstop() {
 # report slave status
 # uses MYSQL_SOCKET - path to mysql socket
 slave_status() {
 # report slave status
 # uses MYSQL_SOCKET - path to mysql socket
 slave_status() {

-       if [ ! -x /usr/bin/mysql ]; then
-               echo >&2 "Slave status not available: 'mysql' program not installed."
+       if [ ! -x /usr/bin/mysql{MYSQL_MAJOR} ]; then
+               echo >&2 "Slave status not available: 'mysql{MYSQL_MAJOR}' program not installed."

                return
        fi
 
        # see if slave status can be reported
                return
        fi
 
        # see if slave status can be reported

-       local err=0 slave_status=$(mysql --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" -e 'show slave status\G')
+       local err=0 slave_status=$(mysql{MYSQL_MAJOR} --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" -e 'show slave status\G')

        if [ -z "$slave_status" ]; then
                # slave not setup
                return
        if [ -z "$slave_status" ]; then
                # slave not setup
                return


@@ -426,26 +416,20 @@ mysqlsubsys() {
        for mysqldir in $DB_CLUSTERS; do
                mysqlstatus "$mysqldir"
                if [ "$MYSQL_STATUS" = "running" ]; then
        for mysqldir in $DB_CLUSTERS; do
                mysqlstatus "$mysqldir"
                if [ "$MYSQL_STATUS" = "running" ]; then

-                       touch /var/lock/subsys/mysql
+                       touch /var/lock/subsys/mysql{MYSQL_MAJOR}

                        return
                fi
        done
                        return
                fi
        done

-       rm -f /var/lock/subsys/mysql
+       rm -f /var/lock/subsys/mysql{MYSQL_MAJOR}

 }
 
 mysqlinit() {
        local clusterdir="$1"
 
 }
 
 mysqlinit() {
        local clusterdir="$1"
 

-       if [ -f /etc/mysqld.conf ]; then
-               nls "Running in \`no cluster compat' mode: can't initialize database."
-               nls "Move /etc/mysqld.conf away and rerun \`$0 init' (new config will be in $clusterdir)."
-               exit 1
-       fi
-

        if [ -f "$clusterdir/mysqld.conf" ]; then
                mysqlgetconfig "$clusterdir"
        else
        if [ -f "$clusterdir/mysqld.conf" ]; then
                mysqlgetconfig "$clusterdir"
        else

-               MYSQL_USER="mysql"
+               MYSQL_USER="root"

                MYSQL_CLUSTER_DIR="$clusterdir"
                MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
                MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"
                MYSQL_CLUSTER_DIR="$clusterdir"
                MYSQL_DATA_DIR="$clusterdir/mysqldb/db"
                MYSQL_PIDFILE="$clusterdir/mysqldb/mysql.pid"


@@ -455,7 +439,7 @@ mysqlinit() {
                MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
        fi
 
                MYSQL_CONFIG="$MYSQL_CLUSTER_DIR/mysqld.conf"
        fi
 

-       show "Initializing MySQL cluster %s" "$clusterdir"; started
+       show "Initializing cluster %s" "$clusterdir"; started

 
        # Check if not exist init database
        if [ -d "$MYSQL_DATA_DIR/mysql" ]; then
 
        # Check if not exist init database
        if [ -d "$MYSQL_DATA_DIR/mysql" ]; then


@@ -465,7 +449,7 @@ mysqlinit() {
                exit 6
        fi
 
                exit 6
        fi
 

-       show "Installing MySQL system tables for $MYSQL_DATA_DIR"
+       show "Initializing MySQL{MYSQL_MAJOR} database for $MYSQL_DATA_DIR"

        busy
        TMP=/tmp TMPDIR=/tmp
 
        busy
        TMP=/tmp TMPDIR=/tmp
 


@@ -487,33 +471,49 @@ mysqlinit() {
        fi
 
        ok=0
        fi
 
        ok=0

-       /usr/sbin/mysqld \
+       /usr/sbin/mysqld{MYSQL_MAJOR} \

                --defaults-file=$MYSQL_CLUSTER_DIR/mysqld.conf \
                --defaults-file=$MYSQL_CLUSTER_DIR/mysqld.conf \

-               --initialize-insecure \
+               --initialize \

                --skip-grant-tables \
                --datadir=$MYSQL_DATA_DIR \
                --user=$MYSQL_USER \
                --skip-grant-tables \
                --datadir=$MYSQL_DATA_DIR \
                --user=$MYSQL_USER \

-               --slave-load-tmpdir=$MYSQL_DATA_DIR \

                --tmpdir=$MYSQL_DATA_DIR \
                --tmpdir=$MYSQL_DATA_DIR \

-               --log-error=$MYSQL_ERRLOG && ok=1
-       [ -f $MYSQL_DATA_DIR/mysql/user.frm ] || ok=0
+               --log-error=$MYSQL_ERRLOG \
+               && ok=1
+       [ -f $MYSQL_DATA_DIR/mysql.ibd ] || ok=0

 
        if [ "$ok" = 1 ]; then
                ok
                cat << END_OF_MSG
 
 
        if [ "$ok" = 1 ]; then
                ok
                cat << END_OF_MSG
 

-PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS!
-This is done, after starting database, in the order shown below,
-with:
+PLEASE REMEMBER TO CHANGE A PASSWORD FOR THE MySQL{MYSQL_MAJOR} USERS!
+
+Start database:
+$ service mysql{MYSQL_MAJOR} start
+
+and set passwords:
+
+For 'root' user (ALL privileges, DB admin), paste command with new password:
+ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword';
+FLUSH PRIVILEGES;
+
+For 'mysql_sysadmin' (RELOAD, SHUTDOWN and REPLICATION CLIENT privileges):
+CREATE USER 'mysql_sysadmin'@'localhost' IDENTIFIED BY 'sysnewpassword' PASSWORD EXPIRE NEVER;
+GRANT RELOAD, SHUTDOWN, REPLICATION CLIENT ON *.* TO 'mysql_sysadmin'@'localhost';
+FLUSH PRIVILEGES;
+
+
+Both into command:
+$ mysql{MYSQL_MAJOR} -u root -p --ssl-mode=disabled -S $MYSQL_SOCKET

 
 

-Add 'mysql_sysadmin' user (RELOAD and SHUTDOWN privileges):
-echo "CREATE USER 'mysql_sysadmin'@'localhost' IDENTIFIED BY 'SOME_RANDOM_PASSWORD'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET
-echo "GRANT RELOAD, SHUTDOWN ON *.* TO 'mysql_sysadmin'@'localhost'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET
+NOTE 1:
+CURRENT TEMPORARY ROOT PASSWORD CAN BE FOUND IN LOG
+(grep for "A temporary password is generated" string):
+$MYSQL_ERRLOG

 
 

-Set password for root user (ALL privileges, DB admin):
-echo "ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpassword'; FLUSH PRIVILEGES;" | mysql --ssl-mode=DISABLED -u root -S $MYSQL_SOCKET

 
 

-NOTE: mysql_sysadmin password should be placed to $MYSQL_CONFIG in
+NOTE 2:
+mysql_sysadmin password should be placed to $MYSQL_CONFIG in

 mysqladmin section. See the manual for more instructions.
 (This user is used at logs rotation and server shutdown)
 
 mysqladmin section. See the manual for more instructions.
 (This user is used at logs rotation and server shutdown)
 


@@ -523,27 +523,27 @@ END_OF_MSG
                cat << END_OF_MSG
 ERROR:
 ERROR:
                cat << END_OF_MSG
 ERROR:
 ERROR:

-ERROR: Initialization of server FAILED!
+ERROR: Installation FAILED!

 ERROR:
 ERROR:
 
 ERROR:
 ERROR:
 

-Examine the logs in /var/log/mysql for more information. You can
+Examine the logs in $MYSQL_ERRLOG for more information. You can

 also try to start the mysqld daemon with:
 
 also try to start the mysqld daemon with:
 

-/usr/sbin/mysqld --skip-grant &
+/usr/sbin/mysqld{MYSQL_MAJOR} --skip-grant &

 
 You can use the command line tool mysql to connect to the mysql
 database and look at the grant tables:
 
 
 You can use the command line tool mysql to connect to the mysql
 database and look at the grant tables:
 

-shell> mysql -u root mysql
+shell> mysql{MYSQL_MAJOR} -u mysql mysql

 mysql> show tables
 
 Try 'mysqld --help' if you have problems with paths. Setting on
 mysql> show tables
 
 Try 'mysqld --help' if you have problems with paths. Setting on

-logging in $MYSQL_DATA_DIR/mysqld.conf gives you a log in /var/log/mysql/query.log that
+logging in $MYSQL_DATA_DIR/mysqld.conf gives you a log in /var/log/mysql{MYSQL_MAJOR}/query.log that

 may be helpful. The latest information about MySQL is available on the
 may be helpful. The latest information about MySQL is available on the

-web at https://www.percona.com/software/mysql-database/mysql.
+web at http://www.mysql.com/.

 
 

-Please check TLD Linux ftp site for newer versions of this package.
+Please check PLD Linux ftp site for newer versions of this package.

 
 Please consult the MySQL manual section: 'Problems running
 mysql_install_db', and the manual section that describes problems on
 
 Please consult the MySQL manual section: 'Problems running
 mysql_install_db', and the manual section that describes problems on


@@ -554,13 +554,13 @@ END_OF_MSG
        fi
 
        # if it's first server, register as default
        fi
 
        # if it's first server, register as default

-       if [ ! -e /var/lib/mysql/mysql.sock ] || [ -L /var/lib/mysql/mysql.sock ] && [ -z "$(readlink /var/lib/mysql/mysql.sock)" ]; then
-               sock=${MYSQL_SOCKET#/var/lib/mysql/} # make it relative if possible
-               ln -s "$sock" /var/lib/mysql/mysql.sock
+       if [ ! -e /var/lib/mysql{MYSQL_MAJOR}/mysql.sock ] || [ -L /var/lib/mysql{MYSQL_MAJOR}/mysql.sock ] && [ -z "$(readlink /var/lib/mysql{MYSQL_MAJOR}/mysql.sock)" ]; then
+               sock=${MYSQL_SOCKET#/var/lib/mysql{MYSQL_MAJOR}/} # make it relative if possible
+               ln -s "$sock" /var/lib/mysql{MYSQL_MAJOR}/mysql.sock

        fi
        # same for config, move to /etc
        fi
        # same for config, move to /etc

-       if [ ! -e /etc/mysql/mysqld.conf ]; then
-               mv "$MYSQL_CLUSTER_DIR/mysqld.conf" /etc/mysql/mysqld.conf
+       if [ ! -e /etc/mysql{MYSQL_MAJOR}/mysqld.conf ]; then
+               mv "$MYSQL_CLUSTER_DIR/mysqld.conf" /etc/mysql{MYSQL_MAJOR}/mysqld.conf

        fi
 }
 
        fi
 }
 


@@ -595,8 +595,8 @@ stop() {
 }
 
 condrestart() {
 }
 
 condrestart() {

-       if [ ! -f /var/lock/subsys/mysql ]; then
-               msg_not_running "MySQL"
+       if [ ! -f /var/lock/subsys/mysql{MYSQL_MAJOR} ]; then
+               msg_not_running "MySQL{MYSQL_MAJOR}"

                RETVAL=$1
                return
        fi
                RETVAL=$1
                return
        fi


@@ -614,7 +614,7 @@ status() {
                        RETVAL=0
                        addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
                        port=${MYSQL_PORT:-3306}
                        RETVAL=0
                        addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
                        port=${MYSQL_PORT:-3306}

-                       socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
+                       socket=${MYSQL_SOCKET:-/var/lib/mysql{MYSQL_MAJOR}/mysql.sock}

                        pid=$MYSQL_PID
                        nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid"
                        [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"
                        pid=$MYSQL_PID
                        nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid"
                        [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"


@@ -631,7 +631,7 @@ status() {
                echo
        done
 
                echo
        done
 

-       for pid in $(/sbin/pidof mysqld); do
+       for pid in $(/sbin/pidof mysqld{MYSQL_MAJOR}); do

                if [[ $pids != */$pid/* ]]; then
                        running="$running $pid"
                fi
                if [[ $pids != */$pid/* ]]; then
                        running="$running $pid"
                fi


@@ -648,7 +648,7 @@ status() {
                        if [ "$MYSQL_STATUS" = "running" ]; then
                                addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
                                port=${MYSQL_PORT:-3306}
                        if [ "$MYSQL_STATUS" = "running" ]; then
                                addr=${MYSQL_BIND_ADDRESS:-0.0.0.0}
                                port=${MYSQL_PORT:-3306}

-                               socket=${MYSQL_SOCKET:-/var/lib/mysql/mysql.sock}
+                               socket=${MYSQL_SOCKET:-/var/lib/mysql{MYSQL_MAJOR}/mysql.sock}

                                nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid"
                                [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"
                                nls "\tunix: %s\n" "$socket"
                                nls "MySQL cluster %s, pid %s\n" "$mysqldir" "$pid"
                                [ -z "$MYSQL_SKIP_NETWORKING" ] && nls "\ttcp:%s:%s\n" "$addr" "$port"
                                nls "\tunix: %s\n" "$socket"


@@ -693,8 +693,8 @@ case "$action" in
        for mysqldir in $DB_CLUSTERS; do
                mysqlgetconfig "$mysqldir"
                # just if mysqld is really running
        for mysqldir in $DB_CLUSTERS; do
                mysqlgetconfig "$mysqldir"
                # just if mysqld is really running

-               if /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
-                       /usr/bin/mysqladmin --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs
+               if /usr/bin/mysqladmin{MYSQL_MAJOR} --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" ping >/dev/null 2>&1; then
+                       /usr/bin/mysqladmin{MYSQL_MAJOR} --defaults-file="$MYSQL_CONFIG" --socket="$MYSQL_SOCKET" flush-logs

                fi
        done
        ;;
                fi
        done
        ;;