📋
SaveYourTime
  • SaveYourTime - Coding Notes
  • Front-End
    • Next.js - Set up with TypeScript
  • Backend
    • Install MySQL on Ubuntu
    • Setup Certbot with route53 on Ubuntu 20.04
    • Configure a Nginx HTTPS Reverse Proxy
    • TypeORM - How to seed data with typeorm-seeding 🔥
  • React Native
    • React Native - Facebook Login
    • React Native - Adding a new Swift file and a Bridge header
  • Tools
    • ESLint
    • Prettier
  • Amazon Web Services
    • AWS - Deploy Next.js Application to AWS S3
    • AWS - Deploy Nest.js Server to Elastic Beanstalk
    • AWS - Setup AWS CloudFront
    • AWS - Configure HTTPS for CloudFront with GoDaddy Domain
    • AWS - Configure HTTPS for Elastic Beanstalk Environments with GoDaddy Domain
    • AWS - Fix Next.js static site hosted on S3 CloudFront routing fails on page reload
    • AWS - Running Puppeteer on AWS EC2
    • AWS - Running Metabase on AWS Elastic Beanstalk
  • GitHub Actions
    • Github - Deploying a React Next.js App to AWS S3 with Github Actions
    • Github - Deploying a Nest.js App to AWS Elastic Beanstalk (Docker Platform) with Github Actions
    • Github - Deploying a Nest.js App to AWS Elastic Beanstalk (Node.js Platform) with Github Actions
  • Others
    • Using Fastlane to automate beta deployments and releases for your iOS and Android apps
    • NodeBB
Powered by GitBook
On this page

Was this helpful?

  1. Backend

Install MySQL on Ubuntu

PreviousNext.js - Set up with TypeScriptNextSetup Certbot with route53 on Ubuntu 20.04

Last updated 4 years ago

Was this helpful?

Download

wget https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb

Install

sudo dpkg -i mysql-apt-config_0.8.16-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server

Check MySQL status

systemctl status mysql

Create a user

CREATE USER 'my_username'@'%' IDENTIFIED BY 'my_password';

To create a user that can connect from any host, use the '%' wildcard as a host part.

Grand all privileges to a user account on all databases

GRANT ALL PRIVILEGES ON *.* TO 'my_username'@'%';

重新載入權限表：

FLUSH PRIVILEGES;
MySQL :: A Quick Guide to Using the MySQL APT Repository
Logo
MySQL :: Download MySQL APT Repository
Logo