658,056 questions
-2
votes
0
answers
25
views
Deleted user Name root for local site. Common solutions haven't worked. ERROR 1045 (28000): Access denied for user 'root'@'localhost' [migrated]
Sorry if this is a silly question.
I'm running a local Wordpress website through WP engine with a MySQL database through AdminNEO on my browser and made a terrible mistake of deleting "root" ...
Advice
0
votes
6
replies
91
views
MySQL set the default unix time
Earlier, I set the time field, int type, to the default time value in unix format.
When adding an entry, the time field accepts the time since 1970 in unix format.
I'm trying to do the same with the ...
-5
votes
0
answers
57
views
Sails.js unable to connect to AWS RDS MySQL (ETIMEDOUT) while Node/Workbench works [closed]
I’m stuck on this since morning and would really appreciate some help.
I created a new AWS RDS MySQL 8.4 instance.
✅ I can connect successfully using MySQL Workbench
✅ I can connect from a Node.js + ...
-3
votes
0
answers
50
views
Creating a user in mysql with readonly permission and that user can't take mysqldump of the database [closed]
I am using AWS RDS as and I have created a user with only SELECT permission. The user should not be able to get the dump but if some flags like:
--single-transaction --skip-lock-tables --no-...
- 1
-2
votes
0
answers
96
views
Query error - can't connect to MySQL server on '127.0.0.1' (111) [closed]
I'm trying to run this code:
annot <- getBM( filters = "ensembl_gene_id", attributes = c("ensembl_gene_id",
"description",
&...
- 11
-1
votes
1
answer
87
views
How do I get a trigger to only delete an associated row in another table in SQL?
I currently have 3 tables:
CREATE TABLE IF NOT EXISTS customers(
ID int unsigned NOT NULL AUTO_INCREMENT primary key,
first_name varchar(50),
last_name varchar(50),
email_address ...
- 1
-11
votes
0
answers
115
views
Does parser_name stored somewhere in information_schema in MySQL
Or this index parameter is "fire and forget" one?
If I create a table in MySQL and then assign the FULLTEXT index to it its possible to assign a parser to such index.
One can use WITH PARSER ...
- 6,448
0
votes
0
answers
119
views
SQL JOIN returning duplicate rows instead of expected results [duplicate]
I am trying to combine data from two tables using a JOIN, but I am getting duplicate rows in the result instead of the expected output.
Here are my tables:
Customers
CustomerID
CustomerName
Orders
...
-2
votes
2
answers
106
views
Row inserted without error, but not showing up in the table [closed]
I added this row and MySQL showed
1 row(s) affected
But even when I counted the rows before and after inserting the row, the count is the same. I believe it means the row was not inserted. Then why ...
0
votes
1
answer
76
views
Exceeded max user connections in python / flask / mysql
I am trying to run a Python / Flask / MySQL app but whenever I try to run it (using the command "python -m flask run"), it gives me this error:
mysql.connector.errors.ProgrammingError: 1226 ...
- 49
0
votes
1
answer
77
views
Adding a column to an SQL query based on join
I would like to left join multiple tables, and in the output have a column that is basically dependent on which table the join came from. So for example, if I have a single join:
SELECT B.Name, A....
- 407
-2
votes
3
answers
64
views
Updating BINARY LOWER/UPPER queries to CAST
I'm using this query to identify misstyped usernames:
SELECT * FROM import_bk
WHERE
(
bk_name = BINARY LOWER(bk_name) OR
bk_name = BINARY UPPER(bk_name) OR
bk_name REGEXP '[0-9]'
)
But I always get ...
- 1,081
-2
votes
0
answers
68
views
Why does COUNT(*) return a different result than COUNT(column_name) in a LEFT JOIN query? [duplicate]
I am trying to count how many orders each customer has. I noticed that COUNT(*) and COUNT(o.order_id) return different results and I don’t fully understand why.
Here is a simplified example:
CREATE ...
- 155
-2
votes
2
answers
133
views
Why after importing a CSV, it is stored alphabetically in the database table?
Why is my CSV file imported into the database alphabetically by the first column product_key? Rather than imported simply line by line, from first line in the CSV to the last line?
My CSV is not ...
- 104
Best practices
0
votes
4
replies
91
views
How to connect MySQL Workbench to Power BI (MySQL 8.0) – connection error
I am working on a project and trying to connect MySQL Workbench to Power BI.
My setup:
MySQL version: 8.0.41
Tool: MySQL Workbench
Power BI Desktop (latest version)
What I tried:
Open Power BI ....
