Good refresher for MySQL. Anyway, Thumps up for that video about indexes and mysql in general that you mentioned at 10:35 , I full series on that would be dope
Thank you. There are just about 2-3 videos left for 2nd section which is about PDO and then 2nd section will be done. 3rd section will have fewer videos than first & 2nd section probably but will still have bunch :). There will definitely be a project because that's the best way to put the things you've learned in this series to practice. We'll build an app from start to end & deploy it as well covering few advanced topics along the way.
Your other comment looks like was removed by RUclips where you asked where you could practice. You can practice using one of those sites like w3schools or Google PHP sandbox
I'm excited to have reached this lesson. Had some issues installing the MySQL container but it finally worked. I have had big issues understanding how to link table IDs. Seeing how clear you made it I wonder why I struggled even after watching some other tutorial. If you make a video on indexes I'll be happy to watch it. For now, I'll move on. Thanks Gio
I had to come here and hit the like button although I am not watching it now (I'll watch it later). Seeing the words MySQL next to PHP is just too sexy :D A MySQL 101??? WOW!!!
Thank you. I mentioned at the beginning of this series (1st video) that prerequisite of this course was just HTML. So I have to keep up to that and make sure that someone who is just starting out with PHP also gets introduced to MySQL to a basic level at least. The next lesson is about PDO & connecting MySQL with PHP but before doing that if someone does not know MySQL it would be confusing & would be assuming that they have MySQL knowledge which would be unfair since I said HTML was the only prerequisite. That is why I decided to include a basic MySQL lesson to introduce the concepts so that future lessons are not confusing :)
Of course it would be great help sir, if you make video in indexes, mysql performance related things in general and how to do database design on large-scale, normalization, and so on which you mentioned in 10:35 timestamp, Waiting for such courses sir.
Have you noticed that when you modified the full_name to be VARCHAR(150), it became nullable. why it didn't keep the unmodified data about the column ?
You used --build on your docker-compose command, and said you did so to rebuild the images. Would be interesting to know why, like, why do you want to rebuild them?
@Program with Gio, please after i learn this MySQL tutorial, do i still need to go and learn SQL and MySQL again from scratch, or this your tutorial on MySQL is enough?
Looks like mysql may not be installed properly, or there might be a permission issue. Its hard to say without more information. I would advise to debug & check docker logs if you are using docker
Hello Gio Thank you for these amazing videos! I have a question , we don`t have to install workbench through docker to have a container for that? If we install Workbench outside of docker how I have access to it? one more question I get this error Access denied for user 'root'@'localhost' (using password: YES), and i read in mysql documentation, we can solve this problem with adding (command: --default-authentication-plugin=mysql_native_password) in docker-compose file, but this solution is not good for production. how we can solve this problem in production?
Hello. Yes you dont install workbench in docker, you install it as a regular software & then just connect to your database. You wont deploy this dockerfile & docker-compose in production, that is for development. For production you would have a separate docker configuration or your hosting provider would set up the database for you depending on which provider you use.
It seems WSL2 docker runs into permission issue ./storage/mysql mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted) programwithgio-db fails to start
Can you help me? I have problem with the volume responsible for storing the data. When I compose the db container it is restarting over and over again but it's not working. I have read many issues but nothing has helped me.
Hey Gio, I could not find a solution on google: create table users( id int unsigned primary key auto_increment, email varchar(255) unique not null, full_name varchar(255) not null, is_active boolean DEFAULT 0 NOT NULL, created_at datetime not null, KEY 'is_active'('is_active') ); In the last line 'is active' is underlined and I'm getting a message: ''is active' is not valid at this position, expecting identifier. This also happens when I do UNIQUE KEY 'email' ('email').
i've got error without running a docker desktop File "/usr/lib/python3/dist-packages/docker/transport/unixconn.py", line 30, in connect sock.connect(self.unix_socket) PermissionError: [Errno 13] Permission denied but when a ran docker desktop everything went well. so i guess docker desktop should run all the time?)
Hello Sir, I pull mysql in my docker. then login programwithgio-db continer and the run mysql -u root -p then give the password root.and it's says ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).and then try again it's work but when i try to make a connetction with MySQL Workbench it's says Faild to connect to MySQL at 127.0.0.1:3306 with user root. If you are free, please give me a solution and i would be thankful to you.
Good refresher for MySQL. Anyway, Thumps up for that video about indexes and mysql in general that you mentioned at 10:35 , I full series on that would be dope
A quick and compact introduction to Mysql database and basic SQL statements.
I liked that it was implemented through Docker :)
Well done!
Thank you 💙💙
The best course. I wonder how many more lessons will there be and will a real project wake up at the end after block 3?
Thank you. There are just about 2-3 videos left for 2nd section which is about PDO and then 2nd section will be done. 3rd section will have fewer videos than first & 2nd section probably but will still have bunch :). There will definitely be a project because that's the best way to put the things you've learned in this series to practice. We'll build an app from start to end & deploy it as well covering few advanced topics along the way.
@@ProgramWithGio Thank you very much. I look forward to it.
Your other comment looks like was removed by RUclips where you asked where you could practice. You can practice using one of those sites like w3schools or Google PHP sandbox
@@ProgramWithGio Thank you.
This PHP course is astonishing! Thanks a bunch!
Glad you like it, thank you 💙
I'm excited to have reached this lesson. Had some issues installing the MySQL container but it finally worked. I have had big issues understanding how to link table IDs. Seeing how clear you made it I wonder why I struggled even after watching some other tutorial. If you make a video on indexes I'll be happy to watch it. For now, I'll move on. Thanks Gio
Awesome, glad you got it working
Would like to learn more about INDEXES 😉👍🏻
👍
Do you have more MySQL classes coming? That was a nice one, clear and easy to follow, thanks
Thank you. I might make separate lessons on it later.
Yes, you should make a series on Databases as well
Noted
Definitely interest in SQL classes. LETS GO.
Awesome 💙
Thank you Gio!
thank you, would love to see vid about db's indexes/optimization, again thank you, learning so much form your tuts
Noted, thank you & you're welcome, happy that you are learning from these videos 🙌
Ah! Gio, I understood much better some previously confusing concepts. Thank you very much.
Glad to hear that, you're welcome 🙌
Great video course!
Will love to learn more about indexes
Awesome
Thank you Gio
You're welcome
I had to come here and hit the like button although I am not watching it now (I'll watch it later).
Seeing the words MySQL next to PHP is just too sexy :D
A MySQL 101??? WOW!!!
Thank you. I mentioned at the beginning of this series (1st video) that prerequisite of this course was just HTML. So I have to keep up to that and make sure that someone who is just starting out with PHP also gets introduced to MySQL to a basic level at least. The next lesson is about PDO & connecting MySQL with PHP but before doing that if someone does not know MySQL it would be confusing & would be assuming that they have MySQL knowledge which would be unfair since I said HTML was the only prerequisite. That is why I decided to include a basic MySQL lesson to introduce the concepts so that future lessons are not confusing :)
Great as always.
Do you perhaps have any book suggestions related to MySQL where advanced topics and behind the scenes stuff is covered too?
Thank you, unfortunately no, I don't have any recommendation at the moment, maybe someone else does & will be able to post it here 💙
Thanks for share.
You're welcome 👍
Thanks for this awesome series, hope you will show us how to deploy the project application on section 3 online at the end of this series🙏🙏🙏
Yup there is video how to deploy it already in section 3. We will also deploy the final project in section 4.
@@ProgramWithGio thanks🙏🙏
Thank you.
You're welcome!
Of course it would be great help sir, if you make video in indexes, mysql performance related things in general and how to do database design on large-scale, normalization, and so on which you mentioned in 10:35 timestamp, Waiting for such courses sir.
Thanks, noted
best explaining mysql basics , when next video Gio?
Thank you. Today the project overview video will be published, and from next week we'll begin working on the project
Have you noticed that when you modified the full_name to be VARCHAR(150), it became nullable.
why it didn't keep the unmodified data about the column ?
Yes because when modifying column we did not specify NOT NULL so by default it made it nullable
Very basic database lesson but a lot has been covered in 25 min.
Just the bare minimums :)
You used --build on your docker-compose command, and said you did so to rebuild the images. Would be interesting to know why, like, why do you want to rebuild them?
If you make changes to docker image or compose file you need to rebuild it, otherwise images are already built and changes you make won't be reflected
@@ProgramWithGio Does that mean just the yml file, or does it also include the Dockerfile or for example any conf files?
@@Chimponaut yup Dockerfile as well and config files too if your config file is loaded within Dockerfile or yml
@@ProgramWithGio alright, thanks for clearing that up. And thanks for all the great videos :)
You're welcome 🙌
@Program with Gio, please after i learn this MySQL tutorial, do i still need to go and learn SQL and MySQL again from scratch, or this your tutorial on MySQL is enough?
This is just a very beginner stuff. It should be enough in the beginning
Hi, i'm getting this error with db image: mysqld: Table 'mysql.plugin' doesn't exist, how to fix this? thanks
Looks like mysql may not be installed properly, or there might be a permission issue. Its hard to say without more information. I would advise to debug & check docker logs if you are using docker
Your content is very informative & valuable. I'm using Xampp. How can I complete this lesson using Xampp?
XAMPP already comes with MySQL installed so you should be able to just use it.
Hello Gio
Thank you for these amazing videos!
I have a question , we don`t have to install workbench through docker to have a container for that? If we install Workbench outside of docker how I have access to it?
one more question I get this error Access denied for user 'root'@'localhost' (using password: YES), and i read in mysql documentation, we can solve this problem with adding (command: --default-authentication-plugin=mysql_native_password) in docker-compose file, but this solution is not good for production. how we can solve this problem in production?
Hello. Yes you dont install workbench in docker, you install it as a regular software & then just connect to your database. You wont deploy this dockerfile & docker-compose in production, that is for development. For production you would have a separate docker configuration or your hosting provider would set up the database for you depending on which provider you use.
@@ProgramWithGio
Thank you
It seems WSL2 docker runs into permission issue ./storage/mysql
mysqld: Cannot change permissions of the file 'private_key.pem.temp' (OS errno 1 - Operation not permitted)
programwithgio-db fails to start
Please DM me on Twitter & share your Dockerfile & docker-compose.yml files. I'll try to help troubleshoot the issue
Gio, why don't you use the built-in database management tool in phpstorm?
I do use it but I prefer workbench sometimes.
Can you help me? I have problem with the volume responsible for storing the data. When I compose the db container it is restarting over and over again but it's not working. I have read many issues but nothing has helped me.
Sure, message me on Twitter & I'll try helping.
Hi Gio, I'm following along you but database that I created in cmd as you did, is not showing in mysql workbench scemas
Hi. How are you connecting to the database from workbench? What host/port are you entering.
If you still need help with this DM me on Twitter and I can help troubleshoot the issue
Hey Gio, I could not find a solution on google:
create table users(
id int unsigned primary key auto_increment,
email varchar(255) unique not null,
full_name varchar(255) not null,
is_active boolean DEFAULT 0 NOT NULL,
created_at datetime not null,
KEY 'is_active'('is_active')
);
In the last line 'is active' is underlined and I'm getting a message: ''is active' is not valid at this position, expecting identifier.
This also happens when I do UNIQUE KEY 'email' ('email').
Hey. You are using single quotes, it should be back ticks for column & index names, `is_active`
@@ProgramWithGio Oh woow lol. Thanks!
i've got error without running a docker desktop
File "/usr/lib/python3/dist-packages/docker/transport/unixconn.py", line 30, in connect
sock.connect(self.unix_socket)
PermissionError: [Errno 13] Permission denied
but when a ran docker desktop everything went well. so i guess docker desktop should run all the time?)
also i got problem with ports? ports are not available. but i have local mysql running, so i just stopped mysql with systemctl stop mysql
yes docker desktop should be running I think. Make sure your ports are not occupied by other services
Hello Sir, I pull mysql in my docker. then login programwithgio-db continer and the run mysql -u root -p then give the password root.and it's says ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).and then try again it's work but when i try to make a connetction with MySQL Workbench it's says Faild to connect to MySQL at 127.0.0.1:3306 with user root. If you are free, please give me a solution and i would be thankful to you.
Hello, I would need to see your setup to be able to help. DM me on twitter & I'll try to help troubleshoot it