Difference between revisions of "SBN - Database Server Notes"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
i.e.: Wikipedia, WordPress, WeeWX, etc... | i.e.: Wikipedia, WordPress, WeeWX, etc... | ||
| − | =Linux Mint= | + | == Installation == |
| + | |||
| + | ===Linux Mint=== | ||
*Mint 19.3 Seems to get MySQL 5.7.30 | *Mint 19.3 Seems to get MySQL 5.7.30 | ||
| Line 14: | Line 16: | ||
*See [[MySQL - Initial Configuration]] for configuration | *See [[MySQL - Initial Configuration]] for configuration | ||
| − | =SparkyLinux= | + | ===SparkyLinux=== |
*Doesn't even have MySQL in the repositories... | *Doesn't even have MySQL in the repositories... | ||
| Line 28: | Line 30: | ||
**(pretty much same as [[MySQL - Initial Configuration]] except the root password is already done...) | **(pretty much same as [[MySQL - Initial Configuration]] except the root password is already done...) | ||
| − | =Set up at least one user in mysql= | + | == NON LOCALHOST ACCESS! == |
| + | |||
| + | ==Set up at least one user in mysql== | ||
*<code>sudo mysql -u root -p</code> | *<code>sudo mysql -u root -p</code> | ||
| Line 40: | Line 44: | ||
If this is to be a remotely accessed Database Server, '<nowiki/>'''localhost'<nowiki/>''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even '<nowiki/>'''*'''') | If this is to be a remotely accessed Database Server, '<nowiki/>'''localhost'<nowiki/>''' will actually be the name/address of the remote machine you'll access '''from'''. (Possibly even '<nowiki/>'''*'''') | ||
| − | =Reference Materials= | + | ==Reference Materials== |
*[http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands] | *[http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm Commands] | ||
| Line 47: | Line 51: | ||
**[https://www.hostinger.com/tutorials/mysql-show-users/ How to Show Users in MySQL on Linux] | **[https://www.hostinger.com/tutorials/mysql-show-users/ How to Show Users in MySQL on Linux] | ||
| − | =Useful Things= | + | ==Useful Things== |
*Restart MySQL | *Restart MySQL | ||
Revision as of 16:14, 22 July 2020
A dedicated server Just to run MySQL...
Then you can simply point all the other things that use it to a central location.
i.e.: Wikipedia, WordPress, WeeWX, etc...
Contents
Installation
Linux Mint
- Mint 19.3 Seems to get MySQL 5.7.30
- Mint 20 Gets MySQL 8.0.20
sudo apt install mysql-server mysql-client php-mysql- Say Yes to Continue
- See MySQL - Initial Configuration for configuration
SparkyLinux
- Doesn't even have MySQL in the repositories...
- Getting MySQL onto SparkyLinux
- Which then gets MySQL 8.0.21
sudo apt install mysql-server mysql-client php-mysql- Say Yes to Continue
- Configuring mysql-community-server
- Pick a good root password...
- I tend to select Use Legacy Authentication Method because Use Strong Password Encryption is annoying as hell. (Your choice here...)
- See MySQL - Initial Configuration B for configuration
- (pretty much same as MySQL - Initial Configuration except the root password is already done...)
NON LOCALHOST ACCESS!
Set up at least one user in mysql
sudo mysql -u root -p- You will be asked for 2 passwords, your own & that of the root database user.
CREATE USER 'someone'@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; EXIT;
(Hint: This'd be a good time to create yourself as that user with your non-admin password of choice...)
If this is to be a remotely accessed Database Server, 'localhost' will actually be the name/address of the remote machine you'll access from. (Possibly even '*')
Reference Materials
Useful Things
- Restart MySQL
sudo systemctl restart mysql.service
- Change a user password
ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';
- Trash a complete database (WARNING! DANGER! DAMAGE LIKELY!)
DROP DATABASE wp_Someblog;
- List existing databases
SHOW databases;
- List existing users
SELECT user,host FROM mysql.user;
