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

|
2019-09-23 06:18:36
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.
MasterZiv 2019-09-23 06:25:18
2019-09-23 06:18:36
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.

MasterZiv 2019-09-23 06:27:06
2019-09-23 06:15:00
Query is like,
Select A.col1, A.col2, B.col3 form A join B on
A.col1=B.col1 and A.col5=B.col5
Index is built on col1+col5 on both tables. Both columns are alphanumeric, so data type is vadchar(128).

This must work.

2019-09-23 08:01:00
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.
MasterZiv 2019-09-23 09:49:06
2019-09-23 08:01:00
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.

MasterZiv 2019-09-23 09:51:01
2019-09-23 08:01:00
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.

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

2019-09-23 10:42:34
MasterZiv 2019-09-23 09:49:06
A query without WHERE is not a query at all.
Should not be executed ever.

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.

MasterZiv 2019-09-23 10:48:16
2019-09-23 10:42:34
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?

2019-09-23 10:50:05
Yes but need some time for it.
MasterZiv 2019-09-23 10:55:02
2019-09-23 10:50:05
Yes but need some time for it.

Do send, and we will have some fun then.

2019-09-23 12:03:00
Ofcourse
2019-09-23 15:33:06
Heres the SQL
2019-09-23 15:33:41
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
2019-09-24 11:18:27
Hii sir i want to know how to give access to admin and user with different privileges using mysql
MasterZiv 2019-09-24 13:17:35
2019-09-24 11:18:27
Hii sir i want to know how to give access to admin and user with different privileges using mysql

man GRANT

2019-09-24 13:19:53
Cannt understand sir
MasterZiv 2019-09-24 13:23:53
2019-09-24 13:19:53
Cannt understand sir

read manuals on GRANT command

2019-09-24 13:24:21
Ok sir thank you
2019-09-25 00:58:17
Also look for “Users and Privileges”
Suneelpotluri 2019-09-25 07:16:35
Hi all…I am Sunil, new member to this group
Suneelpotluri 2019-09-25 07:19:09
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
piterden 2019-09-25 15:15:20
Suneelpotluri 2019-09-25 07:19:09
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

MasterZiv 2019-09-26 13:41:52
This is not the database problem.
I ‘ll delete your question.
Offtopic.
MasterZiv 2019-09-26 16:41:07
https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

MySQL REPLACE() function – w3resourcew3resource
MySQL REPLACE() replaces all the occurrances of a substring within a string.
MasterZiv 2019-09-26 16:41:07
UPDATE tableName SET value1 = youre code1, value2 = youre code2, WHERE …
MasterZiv 2019-09-26 16:41:07
What is the query ?
MasterZiv 2019-09-26 16:41:07
I need to remove the hyphen in credit card numbers for entire table
Manogna 2019-09-26 16:45:56
MasterZiv 2019-09-26 16:41:07
https://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

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

dazimin 2019-09-27 20:01:30
Hello. Is there any solution for automatic failover?
piterden 2019-09-27 20:23:41
dazimin 2019-09-27 20:01:30
Hello. Is there any solution for automatic failover?

What solutions for manual failover do you know?

dazimin 2019-09-27 20:24:10
piterden 2019-09-27 20:23:41
What solutions for manual failover do you know?

Change master to …

dazimin 2019-09-27 20:24:29
I mean smth like Patroni, but for MySQL
piterden 2019-09-27 20:25:42
dazimin 2019-09-27 20:24:10
Change master to …

Programmable change master to …

karandev_user 2019-10-01 10:14:15
Plz given quryas join
Suneelpotluri 2019-10-01 12:13:21
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.
Suneelpotluri 2019-10-01 12:13:35
MySQL is 8 community version
Suneelpotluri 2019-10-01 12:13:56
And application is connecting from Windows server
Suneelpotluri 2019-10-01 13:03:07
piterden 2019-09-25 15:15:20
You can emulate launch from any user with sudo command

Thank you Denis

Suneelpotluri 2019-10-02 17:14:12
Suneelpotluri 2019-10-01 12:13:21
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.

Team, can you pleaSe help me on this

MasterZiv 2019-10-02 19:12:53
Suneelpotluri 2019-10-01 12:13:21
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.

What is MySQL error number?

2019-10-02 23:34:10
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

piterden 2019-10-03 03:40:44
2019-10-02 23:34:10
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?

piterden 2019-10-03 03:42:51
No one can write those queries without a create statement.
2019-10-03 04:54:16
piterden 2019-10-03 03:40:44
Why do you need them?

Because I don’t know this queries

2019-10-03 04:57:24
I don’t know what is the condition to print last 20 city names
Suneelpotluri 2019-10-03 11:35:43
MasterZiv 2019-10-02 19:12:53
What is MySQL error number?

There’s no error number displayed

Suneelpotluri 2019-10-03 11:38:25
mysql_en-236.jpg

2019-10-03 11:46:28
Have you been able to make connection earlier, with same connection string?
MasterZiv 2019-10-03 11:48:49
Suneelpotluri 2019-10-03 11:38:25

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

MasterZiv 2019-10-03 11:49:23
Suneelpotluri 2019-10-03 11:38:25

At last, press yes and forget it

|