How to Host a MySQL Server on Linux

can i do this on a pc🤨

But why does he have a root user with pwsd? Im so stupid... I get the error: ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters.

Great !! Thanks a lot

that firewall will create an issu for u again if u try to connected it from ssh i dont know why

when you already prepared your pi for the video and start panicing a little when he mentions the website

Everything worked great until GRANT ALL ON test.* etc... I get error 1064 although I did everything exactly like in the video, any ideas why?

... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. can somone help me

muchas gracias ¡¡

dont go out of your way to download putty just for a simple ssh connection if your using linode, the web console is terrible but you can just copy and past the ssh command they give you into the windows cmd and instantly have access (after putting your password in ofc)

Enabling the firewall without first allowing the SSH port locked me out of my own droplet when I tried to log in again after this tutorial.

If you have the error of not being able to access your VServer with SSH again, then execute this command:

sudo ufw allow ssh

you have to allow ssh connections to the firewall that is set up in this tutorial

Unable to locate package mysql-server

this will help
sudo apt-get update

sick video man! learned a ton, however how could I use this for an app for example as everytime I download the app on a new device the IP that tries to acces the database obviously changes? Thanks!

i can't access

If you have a problem with GRANT command be noticed that starting from MySQL 8 you should firstly create a user:

CREATE USER SomeUser@'PUBLIC IPV4 ADDRESS' IDENTIFIED BY 'some_password';

and only then you can specify access to this user:

GRANT ALL ON database_name.* TO SomeUser@'PUBLIC IPV4 ADDRESS';

Thanks so much. Helps a ton!

Thanks, been looking for theses for three days

For peaple that get error's do this

CREATE user 'YOURUSERNAME'@'YOURHOST' IDENTIFIED BY 'YOURPASSWORD';
GRANT ALL ON YOURDATABASE.* TO 'YOURUSERNAME'@'YOURHOST;

-----------------

Example->

CREATE user 'test'@'localhost' IDENTIFIED BY 'password12345';
GRANT ALL ON animaldatabase.* TO 'test'@'localhost;

Is it possible to host the database on our PC having Ubuntu OS ?

you are a god

can you do with other platforms except for linode :D

hey man...after i do ufw enable, the firewall is enabled and i cant ssh to the remote system anymore, i have logged off... now its giving me a headache...from what i gathered, i need a direct connection to straighten this out, any thoughts?

I converted an old computer into a Linux server.

Anyone having issues creating the last step u need to do

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

then

GRANT ALL ON DATABASE_NAME.table TO username@localhost IDENTIFIED BY 'password';

You're Welcome

For those who wanna follow along this tutorial, you can create a VM instance of Ubuntu on Google Compute Engine, login using ssh using putty, need to add your public key to the instance and private key to putty

what is the purpose of hosting a sql server on linux?

If you already have a database set up, can you use that database on the linux server?

Thank you Tim! Awsome playlist

write ur own cnc and make a mirai botnet

while running the command 'mysql -u root -p' if you get the error 'ERROR 1698 (28000): Access denied for user 'root'@'localhost'' trying running using a sudo like 'sudo mysql -u root -p'

hey tim can you make a video on how to link Mysql and Kivy. it will be great ... pleaseeee

great stuff

Yesterday I too the day to learn SQL, and today I went all over this playlist.
This was just perfect for me, I'm good to go :)


Elliyahu from Jerusalem

Great series!

Really really!!! Thanks a lot........You are helping us a lot by providing so much nicely explained lessons.......... I Finally learned how to connect to database with Python 😀😀

Is it possible to use a own server like a raspberry pi for this and using then the similar setup?

next video very fast please

Good day!

can use windows operating system or only under linux?

Do you have a video for python ?

I was going to begin with sql and python and this entire series just helped me a lot. Thanks!

thanks.

Tim would you please do some videos about Business intelligence project , like with Microsoft sql server , big up Bro

Great video as always :)

Tim bro. Do kali linux tutorials

<>

first