MySql WorkBench and PHPMyAdmin of Xampp Run together . Use MySql with PHPMyAdmin

yes in this video i'm going to show you how you can connect your uh separate mysql with your phpmyadmin so this is my exam and here uh i have this apache it's working fine but the problem is with mysql okay so when i try to start then it shows yes but ultimately it drops now there is different solutions that okay change port number so i try to change here port number also and one more three place seven so i tried to change port number also but somehow it didn't work not only that i changed the port number from here also from config and then uh standard settings here and this port number still it doesn't work so the main reason is of this bracket which i have installed mysql if you see here my sql this is my sql separately i've installed this okay this is the latest version of mysql 8.0 and this is not same mysql gem myspace is different here this mysql is here different okay so this is not the mysql actually my current mysql is separate i've installed that separately so if you go program files then you can see here sql this one okay so and also along with this mysql workbench is also working with me so this is my sql workbench okay now uh php my admin i want to run but there is problem okay i want to use this mysql the latest mysql 8.0 with uh this uh no with php my admin here it is working perfect you can see quite directly then this mysql is working with workbench but generally we are used to uh you can do all uh mysql operation here like php might mean but normally we are not used to using this smartphone involvement more and more php developers are used to working with this phpmyadmin so let me show you how you can connect this mysql here with phpmy phpmyadmin okay so what you have to do you go to here once again let's go to phpmyadmin folder so c time so my php my admin account is this one here i can see php my admin with that yes this php might be now i will go here and this is the file name config so here i will change the port and all that so first let's go and create a new uh user here okay i'll create here you just in privileges this one this one you just in privileges so server and then users and privileges and then i will create here new account okay let's create here new account so you can see there is an option to create new account here so add account and then new user so i will name it my admin okay then password here as well i'll just put its password right 13 17 so i've just put here password angular 13 so this is username and this is password but apart from that you need to also select this one also that which permission do you want to grab to this user okay so here uh the username is this so apply now the user is created so what we have to do is that let's go to here so in database then connect to database server server status okay so as you can see servant status it is running so here let's do one i'll thing close it again and i'll start so work bench i'll write here then here you can see it is saying localhost 3308 so this is my port number so here first uh root so i had given here the name and here will be port number three three zero eight huh you can see you see local host and then three three zero eight so either you can write localhost or 127.0.2 like this so you have two options so whatever you are comfortable you can write this one so now username here i give my admin admin which i had had just created here so now let's connect let's start this okay now this is fine so i can use my database and schema and all that from here and then i can also if you go to schema then you can see so there are three databases here and these this this this okay now let's open phpmyadmin here just this configuration i changed username password mysql i this one and then here this string the host one okay now let's refresh it and yes you can see from phpmyadmin you can access and not only this you can access myspace from here also as well as you can access your mysql from workbench so it's easy and no problem if this zam sql is not working from here my screen let me start again you can see i need apache here mysql is running somewhere somewhere else so there is no problem i can now work ahead so hope this video helps thanks for watching bye

Channel: Tutorial Rays

Views: 27,448

Keywords:

Id: Q4-ZxSFTikU

Length: 8min 42sec (522 seconds)

Published: Thu Feb 24 2022