Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 258010

An open-source, relational database management system.

1
vote
1answer
this error? Update for Abhik Bose: mysql> grant all privileges on test.* to 'test'@'localhost'; grant all privileges on test.* to 'test'@'localhost'; ^C mysql> grant all privileges on test.* to 'test … '@'localhost'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 4774 Current database: *** NONE *** Query OK, 0 rows affected (0.00 sec) …
asked Nov 17 '17 by Arcticooling
1
vote
2answers
Please consider this code: mysql -u root -p << MYSQL drop user '${test}'@'localhost'; drop database ${test}; create user '${test}'@'localhost' identified by '${psw … }'; create database ${test}; GRANT ALL PRIVILEGES ON ${test}.* TO ${test}@localhost; MYSQL The code outputs the following error for the first command drop user '${test}'@'localhost …
asked Dec 2 '17 by Arcticooling
0
votes
I only gave the name without user and password credentials. This works: mysqldump -u root -p"${rpsw}" "${domain}" > test.sql
answered Dec 10 '17 by Arcticooling
1
vote
2answers
In mysql CLI I did show databases; I then got a list of all DBs. How could I list all users? show users; didn't work, and I didn't find a command here in a quick search. …
asked Nov 16 '17 by Arcticooling
1
vote
1answer
I've created an authorized, all privileged DB user, including a DB with the same name: create user 'test'@'localhost' identified by 'blablabla'; create database test; GRANT ALL PRIVILEGES ON test.* T …
asked Nov 19 '17 by Arcticooling
0
votes
1answer
I tried to recreate a DB user and a DB instance (run over the existing ones), so I ran the following two commands in the Mysql CLI: create user '${test}'@'localhost' identified by '${psw}'; create … ). My question How could I make sure the above commands will run over the existing data if I already have a DB user and a DB instance with the same value (test)? Update after answer mysql -V brings: mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper …
asked Dec 2 '17 by Arcticooling
0
votes
2answers
In Ubuntu server 16.04 xenial in a LEMP stack I executed mysql -u root -p (then root's password), and then, when inside the mysql shell: mysqldump --databases "${domain}" > test.sql but for some … reason this fails: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump …
asked Dec 10 '17 by Arcticooling
1
vote
2answers
This is how I create a MySQL authorized, all privileged DB user and a corresponding DB instance with the same name, directly from Bash: echo "CREATE USER "${domain}"@"localhost" IDENTIFIED BY … \"${dbup}\";" | mysql -u root -p"${dbrp}" echo "CREATE DATABASE ${domain};" | mysql -u root -p"${dbrp}" echo "GRANT ALL PRIVILEGES ON ${domain}.* TO ${domain}@localhost;" | mysql -u root -p"${dbrp}" Could the first two commands merged into one command somehow? …
asked Jan 16 '18 by Arcticooling
-1
votes
2answers
Consider the following code: UPDATE user set password=PASSWORD('NEWPASSWORD_CAME_HERE') WHERE User='root'; Where it is written NEWPASSWORD_CAME_HERE I've putted my password (between the quote marks …
asked Dec 4 '17 by Arcticooling
3
votes
3answers
How to prevent any external logins to my Mysql database? That is, how to make sure that the only way my database could be manipulated is to login to my machine with SSH and work as root/sudoer. My … like Mysql workbench or similar software, and I wish to prevent that as well and to actually lock my database so only my operating system's root user/sudoer could access the DB via mysql -u root -p. To …
asked Nov 16 '17 by Arcticooling
1
vote
1answer
I frequently need to do the following things in MySQL: Create a non-root user Set that user's password Grant that user all privileges Make a database with the same name as the new user Allow usage …
asked Oct 29 '17 by Arcticooling
1
vote
1answer
How to know if a mysql user has all (or some) privileges on a certain DB? Of course, I don't ask how to do so with phpmyadmin, rather, with the mysql CLI. I aim to gather as much as basic data on a …
asked Nov 17 '17 by Arcticooling
1
vote
1answer
The following code drops a DB user and a DB instance by the name of test, if both exists, then creates an authorized, all privileged DB user and a DB instance with the same name (also test). mysql … -u root -p <<-MYSQL DROP user IF EXISTS 'test'@'localhost'; SELECT user FROM mysql.user; DROP database IF EXISTS test; show databases; CREATE user 'test'@'localhost' IDENTIFIED BY '${psw …
asked Dec 6 '17 by Arcticooling
1
vote
2answers
};' | mysql -u root -p Adding this command will change the script to do 5 steps instead 4: Creates an Nginx site conf. Creates a corresponding Let'sEncrypt SSL certificate. Creating a symlink …
asked Nov 7 '17 by Arcticooling
1
vote
1answer
I use the following code as part of a much larger script: mysql -u root -p << MYSQL create user '${DOMAIN}'@'localhost' identified by '${DOMAIN}'; create database ${DOMAIN}; GRANT ALL … PRIVILEGES ON ${DOMAIN}.* TO ${domain}@localhost; MYSQL As you can see it creates an authorized, allprivileged DB user, and a DB instance with the same value (the password will also as the same value …
asked Nov 23 '17 by Arcticooling

15 30 50 per page