Workbench is running on same machine as mysql sever?

|
kamado_tanjiro21 2020-05-11 10:55:26
Master Yoda 2020-05-11 10:53:16
Fire this. Replace ip with your workbench machine ip and pass with your password

where do i find workbench_machine_ip?

Master Yoda 2020-05-11 10:55:47
kamado_tanjiro21 2020-05-11 10:55:26
where do i find workbench_machine_ip?

That is your pc ip on which workbench is running.

kamado_tanjiro21 2020-05-11 10:56:01
the port?
Master Yoda 2020-05-11 10:56:29
kamado_tanjiro21 2020-05-11 10:56:01
the port?

You don’t need port when creating user

Master Yoda 2020-05-11 10:56:59
kamado_tanjiro21 2020-05-11 10:56:01
the port?

Ipconfig if windows. Or ifconfig on linux to find ip

kamado_tanjiro21 2020-05-11 10:58:49
Master Yoda 2020-05-11 10:55:47
That is your pc ip on which workbench is running.

inet one or broadcast one?

Master Yoda 2020-05-11 10:59:11
kamado_tanjiro21 2020-05-11 10:58:49
inet one or broadcast one?

Just do this

Master Yoda 2020-05-11 11:00:10
Create user ‘kartik’@’%’ identified by ‘kartik_123’;
Master Yoda 2020-05-11 11:01:10
Grant select, update, insert, delete ,create on *. * To ‘kartik’@’%’;
kamado_tanjiro21 2020-05-11 11:01:11
0 rows affected
Master Yoda 2020-05-11 11:01:35
Master Yoda 2020-05-11 11:01:10
Grant select, update, insert, delete ,create on *. * To ‘kartik’@’%’;

Then connect with user kartik and password kartik_123

Master Yoda 2020-05-11 11:01:42
From workbench
kamado_tanjiro21 2020-05-11 11:01:43
done
Master Yoda 2020-05-11 11:02:52
Master Yoda 2020-05-11 11:01:35
Then connect with user kartik and password kartik_123

Done??

kamado_tanjiro21 2020-05-11 11:03:01
mysql_en-3018.jpg

Master Yoda 2020-05-11 11:03:39
Workbench is running on same machine as mysql sever?
kamado_tanjiro21 2020-05-11 11:03:47
yes
Master Yoda 2020-05-11 11:04:31
Oh god!! Then why didn’t you tell me. We created user and all😩😩😩
kamado_tanjiro21 2020-05-11 11:04:55
uhhhπŸ˜… sorry i forgot to mention that
Master Yoda 2020-05-11 11:05:34
kamado_tanjiro21 2020-05-11 11:04:55
uhhhπŸ˜… sorry i forgot to mention that

Search this error on Google. You will find. Work a bit hard on this. You certainly will have solution

kamado_tanjiro21 2020-05-11 11:05:48
okay
kamado_tanjiro21 2020-05-11 11:06:22
thanks a lot btw ^_^
JIHA2 2020-05-12 10:21:08
mysql_en-3041.jpg

JIHA2 2020-05-12 10:21:11
I’ve this problem, i need the same research_status_id as above
JIHA2 2020-05-12 10:21:40
Good morning! any help?
MasterZiv 2020-05-12 10:29:50
JIHA2 2020-05-12 10:21:11
I’ve this problem, i need the same research_status_id as above

But what’s the problem?

MasterZiv 2020-05-12 10:32:11
JIHA2 2020-05-12 10:21:08

You have a wrong GROUP BY in the second query.
Non-ansi.

MasterZiv 2020-05-12 10:33:34
JIHA2 2020-05-12 10:21:11
I’ve this problem, i need the same research_status_id as above

Technically speaking, your query (2nd) is incorrect, and it can give any arbitrary result.

JIHA2 2020-05-12 15:43:16
MasterZiv 2020-05-12 10:33:34
Technically speaking, your query (2nd) is incorrect, and it can give any arbitrary result.

How can i fix it friend?

MasterZiv 2020-05-12 15:45:51
JIHA2 2020-05-12 15:43:16
How can i fix it friend?

all fields in the select list must be either under any aggregate function or mentioned in the GROUP BY clause

JIHA2 2020-05-12 15:51:23
any simple example?
JIHA2 2020-05-12 15:53:27
I don’t understand this: under any aggregate function
MasterZiv 2020-05-12 15:56:45
JIHA2 2020-05-12 15:53:27
I don’t understand this: under any aggregate function

Each column must be either enclosed in an expression with one of COUNT/SUM/AVG/MIN/MAX OR must be in GROUP BY

MasterZiv 2020-05-12 15:58:08
JIHA2 2020-05-12 15:51:23
any simple example?

Correct:
select field1, field2, COUNT(field3), SUM(field4)
from theTable
group by field1, field2

Wrong:
select field1, field2, field3, SUM(field4)
from theTable
group by field1, field2

JIHA2 2020-05-12 16:01:56
I know very little English
JIHA2 2020-05-12 16:02:19
I’m trying to understand
piterden 2020-05-12 16:03:37
JIHA2 2020-05-12 16:02:19
I’m trying to understand

We aren’t Englishmen too. The best way to understand is to try it self!

JIHA2 2020-05-12 16:05:40
MasterZiv 2020-05-12 10:29:50
But what’s the problem?

how can I get the same research_status_id that has the highest date of each record_id

MasterZiv 2020-05-12 16:06:23
JIHA2 2020-05-12 16:01:56
I know very little English

Sorry , I don’t know any other language.

piterden 2020-05-12 16:06:35
MAX(date) GROUP BY date
piterden 2020-05-12 16:06:59
MasterZiv 2020-05-12 16:06:23
Sorry , I don’t know any other language.

Eto vraniyo

MasterZiv 2020-05-12 16:07:34
JIHA2 2020-05-12 16:05:40
how can I get the same research_status_id that has the highest date of each record_id

I don’t understand this, this seems meaningless to me.

MasterZiv 2020-05-12 16:08:02
piterden 2020-05-12 16:06:59
Eto vraniyo

Except Albanian , off course!

MasterZiv 2020-05-12 16:08:48
piterden 2020-05-12 16:06:35
MAX(date) GROUP BY date

NO, this is wrong..

piterden 2020-05-12 16:09:21
There is also the language of emotions
JIHA2 2020-05-12 16:09:45
piterden 2020-05-12 16:06:35
MAX(date) GROUP BY date

but I need for every record_id πŸ˜”

piterden 2020-05-12 16:10:36
JIHA2 2020-05-12 16:09:45
but I need for every record_id πŸ˜”

Make a sandbox with your tables and we will try to help you

JIHA2 2020-05-12 16:11:25
Ok
JIHA2 2020-05-12 16:12:18
Sandbox is a e-r model?
piterden 2020-05-12 16:12:39
DB Fiddle
|