Flutter and Mysql connection (mysql1 package)

[@subrotoxing8214]

finally ... a mysql flutter tutorial that does not involve PHP... thank you...

[@animikh04]

Yes

[@run-with-santhosh]

Ya absolutely correct

[@mehmetcaneraslan4684]

Absolutely I agree

[@jazzcorptechnology4163]

Thanks for everything but i have a problem. I can't connect to any database, when i try then i get Socket Exception error.
SocketException (SocketException: Connection refused (OS Error: Connection refused, errno = 111), address = localhost, port = 46200)
What can i do? Thanks

[@divyamanickam-k1i]

i tried this code but i got an error like Socket Exception error.
SocketException (SocketException: Connection refused (OS Error: Connection refused, errno = 111), address = localhost, port = 46300)

[@Savoirinfini509]

me too

[@benerler]

How to do insert? SELECT FROM works but INSERT INTO doesn't work in any way. Tried for 3 days.

[@WaleedLatif-w8z]

i get an error Unhandled Exception: SocketException: The remote computer refused the network connection.
(OS Error: The remote computer refused the network connection.

[@Rezwanullahkhan-my4sb]

me too bro did you find the solution ?

[@husniddintogizov7324]

StateError (Bad state: Cannot write to socket, it is closed)
How can I fix this?

[@mayur16]

I too have this issue ..can anybody solve it please..

[@danilocarneirochristensen5892]

I got this error -> [ERROR:flutter/runtime/dart_vm_initializer.cc(41)] Unhandled Exception: RangeError (byteOffset): Invalid value: Not in inclusive range 0..5: 7; Can u help me?

[@edgarpolanco7831]

Hi when I try to connect the Data Base vía web can’t get access

[@alangonzalez91]

You can't see anything, how do you think of uploading in 720p with such small letters?

[@Fabiboule]

Any solution about the error : Unhandled Exception: SocketException: Connection timed out ?

[@mehmetcaneraslan4684]

Thank you Master, God bless you

[@cloudwhite9185]

This does not work
Unhandled Exception: TimeoutException after 0:00:30.000000: Future not completed

[@poujhit]

I am using another device as a test, and it is connected via adb. but when i connect, i get unhandled exception, connection timeout and connection not allowed.. what to do?

[@DavidMartin-eh5vf]

i have the same issue

[@chind0na]

I think the host on the emulator has to be 10.0.2.2 .
If you're testing from a real phone then allow mysql in your firewall exceptions.

[@anuradhaga]

I am getting this error what should I do?
[ERROR:flutter/lib/ui/ui_dart_state.cc(186)] Unhandled Exception: SocketException: OS Error: Connection refused, errno = 111, address = localhost, port = 44022

[@abdisamadibrahim6534]

same....could you fix it?

[@양은영-n2f]

same... what should i do?

[@specksdude]

any one fixed this bug

[@Fabiboule]

news about it ?

[@llaqtanchis7190]

same problem, could someone solve it?

[@mracipayam]

Thank you, i was struggling with this so much.

[@emmanueltartallini7688]

hi, from the virtual device its ok for me. But when i generate the build and install the app, doesn't work. Any suggest?

[@kitlim9672]

hi, im using my own mobile Android device to test my application. is there any way for it to connect to the database? so far it throws a "Connection Refused" error if the hostname is "localhost" and a "Connection timed out" if I change the hostname to "10.0.2.2"
great vid btw! :)

[@vishnukailas2339]

Unhandled Exception: SocketException: Failed host lookup: '127.0.0.1' (OS Error: No address associated with hostname, errno = 7)...Please help me to solve this issue

[@jesushedo2439]

It seems you should set up MySQL connections settings and put the right parametters on Flutter app

[@vishnukailas2339]

@@jesushedo2439 I think everything is perfect. But still got the same error

[@vishnukailas2339]

[ERROR:flutter/lib/ui/ui_dart_state.cc(157)] Unhandled Exception: SocketException: OS Error: Connection refused, errno = 111, address = localhost, port = 48836

[@poujhit]

@@vishnukailas2339 same here too, any solutions you found?

[@jairg_v]

same here

[@Rakibulhasan-xh7df]

Exception has occurred.
SocketException (SocketException: Connection refused (OS Error: Connection refused, errno = 111), address = localhost, port = 57206)
give me this error.
how to solve this error.

[@K21-335TalhaShahid]

hello bro did your problem solved? if solved then please guide me I am also facing the same problem :(

[@NEXUS_NEWS369]

why you don't update this code it is not working bro :(

[@richardchan8900]

why the return result is always empty?

[@ZNAXNOR]

I got Error: Unsupported operation: RawSocket constructor

[@arjendevoz]

Can you do a tutorial with siging up in flutter using mysql1?

[@jesushedo2439]

Maybe you're looking for this: ruclips.net/video/EioJdY510hM/видео.html

[@dddxnxn5362]

Can you retrieve data select * from table data list? please help me

[@AneeshKumarUSA]

Is there audio in the video?

[@Jordi94xtv]

Thanks. Are the same instructions in android and ios?

[@haberinvarsa]

Hello firebase? Or mysql ? :(

[@JaysonFlores-d1p]

I followed this tutorial and even copied the source files and this doesn't work on the latest version of flutter

[@ZNAXNOR]

got error Error: Unsupported operation: RawSocket constructor

[@ericc2326]

IT WORKS! THANK YOU VERY MUCH!!!

[@chind0na]

How can we get the app to save local user database in sync ?

[@jesushedo2439]

To make sync an async function must use "then()" method, example: getConnection().then((conn)=>{ /* TODO HERE */ });

[@osmyildiz]

Hi thank you for this video. I have used godaddy remote mysql server. When I run app, I got "Unhandled Exception: Error 1045 (28000): Access denied for user 'username'@'91.71.181.111' (using password: YES)" error.. If I give permit to IP address on cpanel then everything is OK. But when I build release apk and run on my phone and click button nothing appears. Do you know how can I handle this stiuation?

[@jesushedo2439]

if your MySQL Server just exposes the ports on the computer, your phone device won't see them, because it should be connected to your computer knowing the IP Address and using the MySQL port. Try MySQL Server to listen out and not to localhost only.

[@tahsinemretelli]

Osman bey problemi çözebildiniz mi? Aynı sorunu yaşıyorum eğer çözdüyseniz mail atabilir misiniz? [e-mail]

[@osmyildiz]

@@tahsinemretelli O sorunu çözemeyince api ile servera bağlanıp (Laravel framework) ordan verilerimi çekmeye başladım. Yani Flutter içinde mysql paketi kullanmıyorum.

[@linomendes7248]

Thank you. Sei que não vai entender mas obg. Estava quebrando a cabeça para achar a solução.

[@husseinalmosawi2001]

Sorry, but what does the 10th line of code do?

[@jesushedo2439]

It's the constructor of the class Mysql

[@officialismailshah]

thanks for this video, I am struggling with this package very much
I am trying to connect to the dedicated server it would be nice you give me some way out....

[@AmitKumar-px4iq]

sir isme jo mysql me create kia hai apne wo bhi pls bta dijie kaise kaise hoga

[@softdev8229]

Is it possible to save image

[@softdev8229]

And how

[@vlycie6628]

will you do a favorites list with provider package and sqflite db? new subscriber here

[@gilmcglory3748]

Thanks so much for this video. Can you please provide the code? It is very hard to see all of the code on the screen. Are you planning to do more? I hope so.

[@jesushedo2439]

For sure! I will push on github. Sorry for the font size, it's my first video 🤣

[@gilmcglory3748]

Got it thanks Jesus.

[@ksreenivas3933]

please make more videos on it

[@Unapersona37438w]

ATTENTION WEB!!! is not supported USING this Packages so this it is worthless and expose credential for those starting like me better go to the other tutorial using API to get data from MYSQL from Flutter

[@medimad-eddineboucenda2250]

Thank you !

[@dahmanedh2036]

Good job

[@emersonuyghur007]

Awesome 😎

[@MrNatucha09]

Thanks!!!

[@TechnoSoft.developer]

هل ممكن ان تتواصل معي لاحل هذه المشكلة وانا ادعمك ما تريد ..
لاني تابعت الفيديو الخاص بك ولم يتم الاتصال بالسيرفر ولا حتى قاعدة البيانات 😢

[@TechnoSoft.developer]

ضروري جدا اخي الكريم؟؟