installing mysql server 5.7

georgejr · February 26, 2019, 8:52am

i installed but mysql 5.7 but it’s not being recogonized… where could the problem be? @odorajonathan @herbert24

herbert24 · February 26, 2019, 9:00am

look for your installation folder called MySQL,then get to the bin folder then run your command for example C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -u root -p

georgejr · February 26, 2019, 9:16am

it is giving me this result

C:\Users\Admin>C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u georgejr -p ‘C:\Program’ is not recognized as an internal or external command, operable program or batch file.

odorajonathan · February 26, 2019, 9:26am

@georgejr have you clicked on the button just below MySQL connections? What is the output? because it must let you to a login to your database.

georgejr · February 26, 2019, 9:55am

thats wat it shows me

odorajonathan · February 26, 2019, 9:57am

yes your MySQL is okay then.

herbert24 · February 26, 2019, 11:22am

i was just giving you an example,just look for your mysql installation folder,then get the path of the bin folder,from that point you will be able to acces the database

georgejr · February 26, 2019, 12:34pm

@herbert24 @odorajonathan it has finally worked

i typed on my cmd “C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u root -p” and then entered password.

herbert24 · February 26, 2019, 12:35pm

okay then thats awesome!!

georgejr · February 26, 2019, 4:10pm

@herbert24 @dkayiwa @odorajonathan this is what i got when trying to run the server

https://pastebin.com/3Duw2A8a

odorajonathan · February 26, 2019, 6:37pm

@georgejr Did you already set your MySQL for example with wamp or xamp prior to setting up the server?

jwnasambu · February 26, 2019, 6:44pm

@georgejr is RefApp 2.9.0 is not released yet choose a lower version.

georgejr · February 26, 2019, 7:22pm

let me try that

georgejr · February 26, 2019, 7:23pm

yeah i did

odorajonathan · February 26, 2019, 7:26pm

first try what @jwnasambu is saying and we see, could the solution

herbert24 · February 27, 2019, 1:20pm

@geargejr according to your logs,i am seeing your connectiong to root as the database.did you create any database called root?

tendomart · February 27, 2019, 2:50pm

@georgejr what are the contents mysql config file ?

did you look into " Failed to connect to the specified database jdbc:mysql://localhost:3306/root?autoReconnect=true&sessionVariables=default_storage_engine%3DInnoDB&useUnicode=true&characterEncoding=UTF-8 ->"

and The distribution requires MySQL database. Please specify database uri (-DdbUri) (default: ‘jdbc:mysql://localhost:3306/@DBNAME@’): jdbc:mysql://localhost:3306/root

jwnasambu · February 27, 2019, 3:09pm

This is his error https://pastebin.com/3Duw2A8a

georgejr · February 28, 2019, 4:56pm

@jwnasambu i tried doing this but it still failed

georgejr · February 28, 2019, 6:53pm

@tendomart i don’t understand this result Failed to connect to the specified database jdbc:mysql://localhost:3306/root?autoReconnect=true&sessionVariables=default_storage_engine%3DInnoDB&useUnicode=true&characterEncoding=UTF-8 ->

for this ( The distribution requires MySQL database. Please specify database uri (-DdbUri) (default: ‘jdbc:mysql://localhost:3306/@DBNAME@’): jdbc:mysql://localhost:3306/root), i tried to run without “root” but it didn’t work out well.