mysql - mckennatim/gitinfo GitHub Wiki
< home
For MYSQL-vscode on sitebuilt.net user = tim
changing password
https://www.techrepublic.com/article/how-to-set-change-and-recover-a-mysql-root-password/
ALTER USER 'root'@'localhost' IDENTIFIED BY 'PASSWORD';
IGNORE sudo: unable to resolve host racknerd-sitebuilt: Name or service not known
CREATE TABLE test.todo_list (
item_id INT AUTO_INCREMENT,
content VARCHAR(255),
PRIMARY KEY(item_id)
);
INSERT INTO test.todo_list (content) VALUES ("My first important item");
SELECT * FROM test.todo_list;
https://www.itzgeek.com/how-tos/linux/ubuntu-how-tos/install-phpmyadmin-with-nginx-on-ubuntu-22-04.
$cfg['blowfish_secret'] = 'CfX1la/aG83gx1{7rADus,iqz8RzeV8x'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
sudo ln -s /usr/share/phpMyAdmin/ /var/www/html/phpmyadmin
mkdir /usr/share/phpMyAdmin/config
chown www-data:www-data /usr/share/phpMyAdmin/config
chmod 750 /usr/share/phpMyAdmin/config
CREATE USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON `%`.* TO 'root'@'localhost';
GRANT ALL PRIVILEGES ON `%`.* TO 'tim'@'%';
GRANT ALL PRIVILEGES ON *.* TO 'tim'@'%';
CREATE USER 'tim'@'localhost' IDENTIFIED BY 'xxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'tim'@'localhost';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON `%`.* TO 'tim'@'localhost';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxx';
ALTER USER 'tim'@'localhost' IDENTIFIED BY 'xxxxx';
sudo systemctl stop mysql
sudo systemctl start mysql
NOTE: root access through phpmyadmin does not work on racknerd
GRANT ALL PRIVILEGES ON *.* TO 'tim'@'%' WITH GRANT OPTION;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'n';
ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket BY 'n';
root@SBSiniz:~# mysqldump -u root -p --opt geniot > geniot.sql
scp geniot.sql [email protected]:~/
mysql -u tim -p geniot < /root/geniot.sql
root@SBSiniz:~# mysqldump -u root -p --opt timecards > timecards.sql
scp timecards.sql [email protected]:~/
mysql -u tim -p timecards < /root/timecards.sql
mongodump
scp -r dump/ [email protected]:~/
mongorestore dump/
info: Forever processing file: index.js
(node:175805) Warning: Accessing non-existent property 'padLevels' of module exports inside circular dependency
(Use node --trace-warnings ... to show where the warning was created)
(node:175805) Warning: Accessing non-existent property 'padLevels' of module exports inside circular dependency
at Object.onceWrapper (node:events:628:26) {
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
}
2022-09-26T14:34:24+0100 index.js:26 () authorized = false ,appid = CYURD118
2022-09-26T14:34:24+0100 index.js:27 () [email protected] geniot
2022-09-26T14:34:24+0100 index.js:31 () undefined
2022-09-26T14:34:27+0100 index.js:17 (Server.authenticate) CYURD006
2022-09-26T14:34:27+0100 mysqldb.js:13 (Object.dbAuth) CYURD006 [email protected] geniot
is a device
2022-09-26T14:34:27+0100 mysqldb.js:17 (Query.) SELECT devid, devpwd, owner FROM devs WHERE devid='CYURD006'
2022-09-26T14:34:27+0100 mysqldb.js:18 (Query.) undefined
2022-09-26T14:34:27+0100 mysqldb.js:19 (Query.) Error: Cannot enqueue Query after fatal error.
at Protocol._validateEnqueue (/home/services/iot/broker/node_modules/mysql/lib/prot
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'nji9ol';