Edit User Data

Edit User Data Home ince.one Home

mysql

mysql -u root -p
-----------

mysql -u admin -p$(cat /etc/psa/.psa.shadow)

---------

DROP USER IF EXISTS 'root'@'localhost';

CREATE USER 'root'@'localhost' IDENTIFIED BY 'kkk333!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

--------------

ALTER USER 'root'@'localhost' IDENTIFIED BY 'kkk333!fffdde>';
FLUSH PRIVILEGES;

-------------------------------------
-------------------------------------

SHOW DATABASES;

CREATE DATABASE dbadi;

DROP DATABASE dbadi;

USE dbadi;

SHOW TABLES;

DESCRIBE tablo_adi;

SHOW COLUMNS FROM tablo_adi;

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(100)
);

DROP TABLE tablo_adi;

INSERT INTO users (name, email) VALUES ('Ali', 'ali@example.com');

SELECT * FROM users;

SELECT * FROM users WHERE id = 1;

UPDATE users SET name='Mehmet' WHERE id=1;

DELETE FROM users WHERE id=1;

SELECT User, Host FROM mysql.user;

CREATE USER 'kullanici'@'localhost' IDENTIFIED BY 'sifre';

GRANT ALL PRIVILEGES ON dbadi.* TO 'kullanici'@'localhost';
FLUSH PRIVILEGES;

DROP USER 'kullanici'@'localhost';

SELECT VERSION();

SHOW PROCESSLIST;

https://copilot.microsoft.com/shares/yCgLZKMSmZpqDB4qJirHB

Edit Delete