Skip to content

Instantly share code, notes, and snippets.

@bugcy013

bugcy013/MySQL install non root user

Created September 8, 2014 05:06
Show Gist options
  • Save bugcy013/9da9ff1ba0c8ab6f2861 to your computer and use it in GitHub Desktop.
Save bugcy013/9da9ff1ba0c8ab6f2861 to your computer and use it in GitHub Desktop.
Download ZIP
Install MySQL Non-root user
Raw
MySQL install non root user
Step1: Download MySQL Community Server x.x.x TAR Archive and untar it in user home folder
Step2: Create a my.cnf file in user home directroy
[server]
user=username
basedir=/home/username/mysql
datadir=/home/username/sql_data
socket=/home/username/socket
port=3666
Step3: Create directory with the below command
./scripts/mysql_install_db --defaults-file=~/my.cnf --user=username --basedir=/home/username/mysql --datadir=/home/username/sql_data --socket=/home/username/socket
Step4: Changing the path in mysqld_safe file
Step5: Starting the mysql server.
./bin/mysqld_safe --defaults-file=~/my.cnf &
Step6: Setting password for root user
mysql --socket=/home/testmysql/socket -u root
UPDATE mysql.user SET Password=PASSWORD('hereweg0') WHERE User='root';mysql --socket=/home/testmysql/socket -u root -p
Error message in starting mysql:
mysqld.log'.
cat: /var/lib/mysql/dhana55.pid: Permission denied
rm: cannot remove `/var/lib/mysql/dhana55.pid': Permission denied
130823 15:07:32 mysqld_safe Fatal error: Can't remove the pid file:
/var/lib/mysql/dhana55.pid
Please remove it manually and start mysql/bin/mysqld_safe again;
mysqld daemon not started
mysql/bin/mysqld_safe: line 128: /var/log/mysqld.log: Permission denied
@Note: the above path is not the correct path. Please use the config and script within the user home directory.
[testmysql@dhana55 bin]$ 130826 07:01:38 mysqld_safe Logging to '/home/testmysql/sql_data/dhana55.err'.
130826 07:01:38 mysqld_safe Starting mysqld daemon with databases from /home/testmysql/sql_data
[testmysql@dhana55 bin]$ mysql --socket=/home/testmysql/socket -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.33 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| ABC |
| mysql |
| test |
+--------------------+
4 rows in set (0.02 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment