mysql manual

in mysql

install mysql on ubuntu https://hevodata.com/learn/installing-mysql-on-ubuntu-20-04/

  1. 创建数据库

    CREATE DATABASE 'newdatabase';
  2. 设置创建用户并设置密码

    -- # Host: %表示支持任意连接,localhost表示只允许本地连接
     CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'newpassword';
     CREATE USER 'newuser'@ '%' IDENTIFIED BY 'newpassword';
    
  3. 授权

    -- 如果需要给用户创建数据库的权限,则可以这样设置
    GRANT ALL PRIVILEGES ON *.* to my_user@'%'; -- 这里的my_user 跟第五步是相同的
    
    GRANT ALL PRIVILEGES ON newdatabase.* TO 'newuser'@'localhost';
    FLUSH PRIVILEGES;
  4. 重新登陆

    mysql -u kirkzhang -p

Comment and share

摘要: 当应用程序的数据库组件在应用程序升级过程中被更新时,大型的关键的应用程序可能会经历几十个小时,甚至更长的停机时间。app的数据库组件在应用程序升级期间进行更新。Oracle数据库推出了基于版本的重新定义(EBR),这是一项革命性的功能,可以在不间断的情况下在线升级应用程序。革命性的功能,它允许在线应用升级,并保证应用的不间断可用性。

Continue reading

作者寄语:This book is dedicated to my family.Even though you’re far away, you are still in my heart.

About the Author: Jason Price is a freelance consultant and former product manager of Oracle Corporation. He has contributed to many of Oracle’s products

Continue reading

Neovim

in neovim

官方文档: https://neovim.io/doc/user/

摘要: 后面具体学习时候再补充

Neovim Installation

针对不同的平台直接在github上下载对应的版本的文件,然后直接解压放到/usr/bin/nvim

Configuration

nvim的配置文件放在了~/.config/nvim目录下,创建init.lua文件和lua目录,在lua目录下放置你的配置文件,简单的init.lua入选所示

--[[ init.lua ]]

-- LEADER
-- These keybindings need to be defined before the first /
-- is called; otherwise, it will default to "\"
vim.g.mapleader = ","
vim.g.localleader = "\\"

-- IMPORTS
-- require('vars')      -- Variables
-- require('opts')      -- Options
-- require('keys')      -- Keymaps
-- require('plug')      -- Plugins

Set Variables

你的变量的可以放在var.lua文件中就可以进行全局变量的定义

Manage plugins with Packer

here is list including more awesosme neovim plugins

where i installed the Packer at the ~/.config/nvim/

Comment and share

Author's picture

kirkzhang

author.bio


author.job


Canton