Is it possible to start MySQL service from non root user?

Sometimes the query has where clause also
Select A.col1, A.col2, B.col3 form A join B on
A.col1=B.col1 and A.col5=B.col5
Where A.col4 like ‘%some text%’
Also tried by making index on A like col1+col2+col4. No difference in execution.

“Sometimes” means it’s a different query.

This must work.

Means, generally Query without where is executed, 10 times a day.
Query with where is executed once or twice a day. These are basically reports.
In both cases, index is present but not used.
Index 2 on col1+col2+col4
Index1 on col1+col2
Moreover index1 can be removed but is intentionally kept. Still of no use.

A query without WHERE is not a query at all.
Should not be executed ever.

If you still need help post DDL and the query text.
And the execution plan if you have it.

Don’t agree to this. Query is built depending on business requirements.
For the time being let’s keep this aside and focus on issue of non-usage of index.

Are you going to post SQL & DLL?

Yes but need some time for it.

Do send, and we will have some fun then.

Ofcourse

Heres the SQL

SELECT
A.derulevalue, B.applicationid, A.sessionid
FROM
Dev.brms_rules_result A
inner join
Dev.brms_gds_request B ON B.applicationid = A.applicationid
AND B.sessionid = A.sessionid

Hii sir i want to know how to give access to admin and user with different privileges using mysql

man GRANT

Cannt understand sir

read manuals on GRANT command

Ok sir thank you

Also look for “Users and Privileges”

Hi all…I am Sunil, new member to this group

Is it possible to start MySQL service from non root user? I see from MySQL 5.7, default MySQL user can’t login at os level. Which cases we need os user MySQL login? Kindly let me know

You can emulate launch from any user with sudo command

This is not the database problem.
I ‘ll delete your question.
Offtopic.

https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

UPDATE tableName SET value1 = youre code1, value2 = youre code2, WHERE …

What is the query ?

I need to remove the hyphen in credit card numbers for entire table

Can you say what should be str, find str, replace with in my case

Hello. Is there any solution for automatic failover?

What solutions for manual failover do you know?

Change master to …

I mean smth like Patroni, but for MySQL

Programmable change master to …

Plz given quryas join

Team, can some one please help me out. We are facing “Unknown initial characterset 255 received from server. Initial client character set can be forced via the characterEncoding property.

MySQL is 8 community version

And application is connecting from Windows server

Thank you Denis

Team, can you pleaSe help me on this

What is MySQL error number?

MySQL: 1- List the last 20 city names stored in the database.

2- List 2 countries with population between 211000000 and 300000000 and are
located in Asia and are sorted from names started with z to a.

Please write this querys

Why do you need them?

No one can write those queries without a create statement.

Because I don’t know this queries

I don’t know what is the condition to print last 20 city names

There’s no error number displayed

Have you been able to make connection earlier, with same connection string?

This is JDBC problem, not of mysql, solve in your Java application

At last, press yes and forget it