InstallingAboutUsOnLinux/InstallMysql
Back to InstallingAboutUsOnLinux
# Install MySQL 5.0.22 Ver 8.41 sudo apt-get install mysql-server sudo apt-get install libmysqlclient15-dev
Initialize Database
- Creating a User:
echo "CREATE USER 'wiki'@'%' IDENTIFIED BY 'wiki'" | mysql -u root echo "GRANT ALL PRIVILEGES ON * . * TO 'wiki'@'%' IDENTIFIED BY 'wiki' \ WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 \ MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0" | mysql -u root echo "GRANT ALL PRIVILEGES ON \`wiki\\_%\` . * TO 'wiki'@'%';" | mysql -u root
- Populate the DB with tables:
echo "create database aboutusbot" | mysql -u root -D mysql echo "create database aboutusbot_test" | mysql -u root -D mysql
PHPMyAdmin (Optional)
sudo apt-get install phpmyadmin ln -s /usr/share/phpmyadmin/ /www/htdocs/
You have your phpmyadmin installed at http://localhost/phpmyadmin
