Man I was really needing this. I was struggling with the fact that the MySQL installer doesn't let you install more than 1 instance. You explained everything very well!
@BladeDMC
4 жыл бұрын
Errata corrige for point 8 in description: mysql -u root -p --port=3307 (without "-p" and with "Port" you have errors). Thank you very much for your help!
@MuhammadZahid-ld9yy
4 жыл бұрын
i did it instace is installed but service is not starting for new instace. what should i do ?
@chrismerani5330
4 жыл бұрын
I have the same issue
@antoinevigithraj
3 жыл бұрын
@@chrismerani5330 Any luck?
@conmancybe8423
Жыл бұрын
Excellent, and very Informative. Just what i needed my friend!
@user-lp8cr7te8b
3 ай бұрын
hello...great efforts ... i executed it without errors first time ... but second time it doesnt allow me.. error msg Install/Remove of service denied kindly help me to solve the issue
@rohinikarumuri3430
4 жыл бұрын
I tried same procedure but got stuck while starting services with net start service.Please help me in this.
@grahamboyd5768
4 жыл бұрын
very easy and simple, however I have an issue in step 7 where its starts and stops whilst enabling
@HimalayaGarg
4 жыл бұрын
Very informative tutorial. You should have also change the my.ini config file location. @12:10 it is showing old location. I guess it can be configured in server variables.
@nguyentrangg8755
4 ай бұрын
can i setup master slave replication from this?
@AhemKhanna
2 ай бұрын
I can't see versions except 5.8
@den_agung
5 жыл бұрын
Thankyou sir, im looking this for the entire of my life :D
@TechBrothersIT
5 жыл бұрын
Guess what your prayers are heard; ) Let's see if you will keep up with number of videos, This is going to be very detail MySQL DBA Tutorial :) Adding 40-50 videos on workbench today. Please keep posting your comments/ suggestions. I appreciate your time.
@den_agung
5 жыл бұрын
@@TechBrothersIT i have a case that maybe i will use more than 100000 tables in a single mysql database. What do you think about it? Will it work?
@TechBrothersIT
5 жыл бұрын
@@den_agung I don't think so there is any limit on creating those many tables in single database, search on google and you might find if there is any limit per DB. I will give a try too. As the tables are saved as files in a directory on windows or linux, not sure if Operating system has some limits on creating those many files in single directory. Can you please share more info regarding your scenario? would not it be hard to maintain these many tables in single database, backup restore etc?
@xrays3879
4 жыл бұрын
--install MYSQLQA --defaults-file="c:/MYSQLQA/mysqlqa.ini" Install/Remove of the Service Denied! Help me pls
@amitroy-cx2qb
2 жыл бұрын
Please open the CMD prompt with Admin.
@AliHasan-fn8nq
2 жыл бұрын
Service not starting? At this point your service has been created and you can see it in Services. We first delete it. To delete use as Administrator SC DELETE NAMEOFSERVICE Restart system. Now Start creating .ini. Copy paste original .ini content in a new notepad file. Do the changes mentioned. When saving make sure you select "All files", don't append extension and ANSI should be selected.
@giparekh
4 жыл бұрын
I have installed MySQL 5.5 on my server. How can I install another instance of MySQL 8.0 on the same server? From this video i can see you have installed MySQL8.0 from MySQL 8.0. Thanks!
@goussevserge
5 жыл бұрын
Very good video & walk-through!
@gtsmeg3474
2 жыл бұрын
09:48 I'm having this error : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) as I'm using same password as the installation
@upenderthakur3692
5 жыл бұрын
Thanks for the great video Sir. Can we have video on Mysql Master Slave replication.
@TechBrothersIT
5 жыл бұрын
I really do have to make that. Soon will take care of that.
@ScriptcasecommunityIt01
4 жыл бұрын
Very good tutorial. Thank you!
@MikeBaron2009
3 жыл бұрын
the second instance does not start
@knowledgegain2247
4 жыл бұрын
its giving me an error( Install/Remove of the Service Denied!)
@mogesretta2279
4 жыл бұрын
run cmd as admin
@Dafugcasimock
3 жыл бұрын
Thanks man, good video
@andriinebylovych294
4 жыл бұрын
thank you so much...
@TechBrothersIT
3 жыл бұрын
You're most welcome
@awkashshrivastava928
4 жыл бұрын
sir I have not done it please help me
@usertuserb7057
4 жыл бұрын
Thank you Very Very Very MATCH , very useful for me. but please if i d'ont have the first password , how can'i start my new service?
@richardlee6310
5 жыл бұрын
When I do the same thing, but I have stuck at the net start MYSQLQA, show the error message said "NET HELPMSG 3534", please help!
@tuanngocnguyen2644
4 жыл бұрын
I was the same. Have you fixed it yet?
@aaaa1339
4 жыл бұрын
This happened to me as well and I redid everything and got it working. I suspect I might have forgot to uncomment the basedir line in .ini file
@tusharkaushik79
3 жыл бұрын
@@aaaa1339 I have uncmmented base dir line bt its not working
@skullmurdoc
2 жыл бұрын
@@tusharkaushik79 Your .ini file probably got saved with UTF-8 encoding instead of ANSI.
@memefox1985
2 жыл бұрын
No longer works :( Service crashes on startup command line The MYSQL0002 service is starting. The MYSQL0002 service could not be started. The service did not report an error. gui The MYSQL0002 Service on local computer started and then stopped. some services stop automatically if they are not in use by other services or programs
@illzn06
6 ай бұрын
I am getting this error. How did you resolve it?
@memefox1985
6 ай бұрын
@@illzn06I never did. I gave up and ditched MySQL and used PostgreSQL
Пікірлер: 41