Tips and tricks

image
Add user / admin to mysql
Posted on May 31 2023 / in WordPress

go to MySQL service from the terminal

use 

sudo mysql

or

sudo mysql -u root -p

if you have a password

then

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';

then

GRANT ALL PRIVILEGES ON * . * TO 'new_user'@'localhost';

then, to restart privileges 

FLUSH PRIVILEGES;

check users with

SELECT user,host FROM mysql.user;

{"type":"main_options","images_arr":"'#ffffff'","enable_ajax":"off","soundcloud_apikey":"","bg_isparallax":"off","bg_slideshow_time":"0","bg_transition":"slidedown","site_url":"https:\/\/digitalzoomstudio.net","theme_url":"https:\/\/digitalzoomstudio.net\/wp-content\/themes\/qucreative\/","blur_ammount":"26","width_column":"50","width_section_bg":"","width_gap":"30","border_width":"0","border_color":"#ffffff","translate_cancel_comment":"Cancel reply","translate_leave_a_comment":"Leave a comment","translate_leave_a_comment_to":"Leave a comment to","is_customize_preview":"off","width_blur_margin":"30","gallery_w_thumbs_autoplay_videos":"off","content_enviroment_opacity":"30","menu_enviroment_opacity":"70","base_url":"https:\/\/digitalzoomstudio.net"}
{"type":"darkfull"}