Questions tagged [mysql]
MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.
1,945
questions
0
votes
0
answers
6
views
Initializing database using mysql-operator
I have a rather complex application, with several applicative components and a MySQL database. I am using kubernetes and Helm manage it. I would like to clusterize the database using mysql-operator, ...
4
votes
1
answer
9k
views
MySQL Workbench * could not be fetched
I set up a MySQL Server on a Ubuntu machine.
I added a user A with only access to one Database 'B'.
If I log in with it in MySQL Workbench, it shows me:
Tables could not be fetched
Views could not ...
0
votes
0
answers
6
views
Combining Tables in MySQL [migrated]
I am in need of some help
I have a Database that hold product records as well as sale location data and I need to have a data set returned with data from different tables
So far I have tried the ...
0
votes
0
answers
13
views
mysql - show all users/hosts with privileges to access a certain database [migrated]
Is there a way to list all users/hosts that have been granted access to a database? I know I can do this:
> show grants for someuser;
+---------------------------------------------------------------...
-2
votes
0
answers
16
views
there's packet loss in my .pcap file and i want to find the cause for it [closed]
[enter image description here][1]
https://i.sstatic.net/fzMo9dj6.png
0
votes
1
answer
4k
views
Import a local SQL File To a Remote Server Using SSH Tunnel
I have a connection between my localhost and a remote server using putty SSH tunnel.
Thats fine.
Now I need a command to get the sql file on my local machine i.e. c:\folder\test.sql and import it ...
0
votes
1
answer
3k
views
MySql error: Access denied for user 'root'@'localhost' (using password: NO)
I am trying to retrieve my data from MySQL to be used in python. But it prints out TypeError: 'NoneType' object is not iterable The server log shows that Access denied for user 'root'@'localhost' (...
1
vote
0
answers
58
views
systemd: ensure, service is started after mysql
I have a systemd path unit, which watches a config file to apply db changes if the config file changes. To ensure the path unit runs after mysql, I added these lines:
Wants=mysqld.service
After=mysqld....
2
votes
1
answer
677
views
Cannot install mariadb-server on Debian "There is a MariaDB/MySQL server running" (because of Akonadi?)
Preamble, I've done some research and as usual we have a cornucopia of similar questions but not exactly covering the described title:
https://askubuntu.com/questions/1407756/akonadi-on-kde-cant-...
2
votes
1
answer
4k
views
Can't start mariadb service with brew in mac
I am trying to start mariaDB in mac with brew services.
I run brew services stop --all
jenkins-lts none
mariadb none
memcached none
mysql none
[email protected] ...
0
votes
2
answers
4k
views
Where to retrieve MySQL Database Backup? Centos 6
Had taken a look at: Where Are Databases Located - MySQL File Location
Didn't seem to help much.
I used this for a single MySQLDatabase backup: http://www.tecmint.com/mysql-backup-and-restore-...
2
votes
1
answer
4k
views
"Could not create unix socket lock file" with MySQL 5.7.10 on OS X 10.11.2
I've been trying to install MySQL 5.7 on OS X El Capitan using Homebrew, however when it came to getting the server up and running, I cannot seem to get a lock file created.
When I run mysqld_safe, ...
12
votes
6
answers
172k
views
How do I start a MySQL server on Windows?
I've installed a MySQL server onto my computer and when I first installed it, it ran automatically. Now I've restarted my computer it is no longer running. What file do I need to run to get it back up ...
0
votes
3
answers
7k
views
MySQL 8.0.16 Community Edition install stopping at "Starting the Server" step on Windows
I am attempting to install MySQL 8.0.16 Community Server on Windows 10. I keep getting to the "Apply Configuration" step, I hit 'Execute", and then I get to the "Starting the Server" step and it ...
1
vote
1
answer
66
views
MySQL: Converting Row to Columns Based on Field Values
I am using MySQL Workbench 8.0.
I will break my question into two parts as I believe the first part will be straightforward (but is slightly beyond my current SQL knowledge level) but the second part ...