Mysql -u root error | Laravel | Page 1

polar harness Feb 4, 2024, 2:17 AM

#

Hello. I have been following a tutorial in laravel and now we're on to creating a database through terminal but It seems like the mysql -u root command doesn't work on my terminal. I have also included already the C:\xampp\mysql\bin PATH in env. Thanks in advance

clear snow Feb 4, 2024, 2:20 AM

#

I think that MySQL did not install in your platform

#

didn't you use xampp for server program?

polar harness Feb 4, 2024, 2:21 AM

#

clear snow I think that MySQL did not install in your platform

#

Yes, sir. Im using xampp

clear snow Feb 4, 2024, 2:22 AM

#

ah, so why do use this command?

patent oar Feb 4, 2024, 2:22 AM

#

Your first screenshot is in Powershell

#

the second is in CMD

polar harness Feb 4, 2024, 2:23 AM

#

My worry here is that I can create the database through localhost/phpmyadmin but I'm worried that I might have a problem when we go to the "Migration" stuff (tho I dont know about it yet)

polar harness Feb 4, 2024, 2:23 AM

#

patent oar Your first screenshot is in Powershell

Im sorry. Let me try the command on powershell as well

polar harness Feb 4, 2024, 2:23 AM

#

patent oar the second is in CMD

#

This one on same terminal as first one

clear snow Feb 4, 2024, 2:24 AM

#

excute your command in powershell

polar harness Feb 4, 2024, 2:25 AM

#

clear snow ah, so why do use this command?

The tutorial i'm following executed "mysql -u root" first in powershell before creating database on it

#

I'm kind of just trying to follow everything he does hehe

polar harness Feb 4, 2024, 2:25 AM

#

clear snow excute your command in powershell

Yes first screenshot is in powershell sir

patent oar Feb 4, 2024, 2:26 AM

#

mysqladmin.exe -u root

#

you're on windows

#

he's on linux I imagine

polar harness Feb 4, 2024, 2:27 AM

#

patent oar mysqladmin.exe -u root

Wait what

#

This works

patent oar Feb 4, 2024, 2:27 AM

#

Yeah, you're following a linux tutorial 😄

polar harness Feb 4, 2024, 2:27 AM

#

But the result is kinda too many than what he got

#

Let me show it to you to confirm if it should be the expected result

#

Thank you so muuuuch

#

#

patent oar Feb 4, 2024, 2:28 AM

#

Your best bet, is look at the Laravel Sail guide, as it uses Docker and gives you a Linux environment.

Windows has historically not played as nicely

polar harness Feb 4, 2024, 2:28 AM

#

#

Im not gonna send all anymore

#

It gave me tons of this

#

Is this the expected result I should get?

#

#

The tutorial i'm following only got this

#

#

Still can't create database 😭

patent oar Feb 4, 2024, 2:30 AM

#

you're not in mysqladmin yet#

#

Check in Xampp to make sure that the mysql server is running

clear snow Feb 4, 2024, 2:30 AM

#

did you start mysql server?

#

in xampp?

polar harness Feb 4, 2024, 2:30 AM

#

#

Yes i did, sirs

clear snow Feb 4, 2024, 2:31 AM

#

can you connect mysql by using navicat?

polar harness Feb 4, 2024, 2:31 AM

#

What's weird is

#

He was on this directory when he used the command

#

Then became here when after he entered it

clear snow Feb 4, 2024, 2:31 AM

#

polar harness

this is directory root

patent oar Feb 4, 2024, 2:31 AM

#

Is it just me, or does that look like a really old version of Xampp (granted I've not touched it in about 10 years)

polar harness Feb 4, 2024, 2:32 AM

#

clear snow can you connect mysql by using navicat?

I am not familiar with navicat sir

polar harness Feb 4, 2024, 2:32 AM

#

patent oar Is it just me, or does that look like a really old version of Xampp (granted I'v...

The tutorial I'm following is 3 years ago, this xampp im using I just downloaded it last year

polar harness Feb 4, 2024, 2:32 AM

#

clear snow this is directory root

Yes sir and after he used mysql -u root he got changed into that mariadb none

clear snow Feb 4, 2024, 2:34 AM

#

yeah he used MariaDB not MySQL

patent oar Feb 4, 2024, 2:34 AM

#

In CMD, navigate to the directory you installed mysql in (probably c:\Program Files or similar)

polar harness Feb 4, 2024, 2:34 AM

#

patent oar In CMD, navigate to the directory you installed mysql in (probably c:\Program Fi...

C:\xampp\mysql\bin

#

This one?

patent oar Feb 4, 2024, 2:35 AM

#

yep

#

so in the command prompt type:

cd c:\xampp\mysql\bin

#

now type

polar harness Feb 4, 2024, 2:35 AM

#

#

On it now sir

patent oar Feb 4, 2024, 2:35 AM

#

mysql -u root -p

#

does that now work?

polar harness Feb 4, 2024, 2:35 AM

#

#

HOOO it did!

patent oar Feb 4, 2024, 2:35 AM

#

Wahey

polar harness Feb 4, 2024, 2:35 AM

#

Should I do the same on terminal?

#

I mean powershell of vscode

patent oar Feb 4, 2024, 2:36 AM

#

If that's what you're going to be working in

polar harness Feb 4, 2024, 2:36 AM

#

Yes thats where I'm working in

patent oar Feb 4, 2024, 2:36 AM

#

you should only need this for the first bit fortunately 🙂

#

once you've got the databse/user created etc, you'll be using migrations etc

polar harness Feb 4, 2024, 2:36 AM

#

So everytime I have to migrate i will redirect to this first?

patent oar Feb 4, 2024, 2:36 AM

#

no

polar harness Feb 4, 2024, 2:36 AM

#

patent oar once you've got the databse/user created etc, you'll be using migrations etc

Yes that was my worry 😭

patent oar Feb 4, 2024, 2:36 AM

#

when you migrate, you'll use artisan

polar harness Feb 4, 2024, 2:37 AM

#

I see I see

patent oar Feb 4, 2024, 2:37 AM

#

from vscode, in the base of your application

clear snow Feb 4, 2024, 2:38 AM

#

patent oar from vscode, in the base of your application

thank you I learned about it from you

polar harness Feb 4, 2024, 2:38 AM

#

I see I see. So I actually only needed to do this for creating the database on terminal like how he did?

#

I'm not getting the "Query OK. 1 row affected (0.001 sec) yet tho

#

😭

#

#

Still stuck on this

#

Database still not on phpmyadmin yet too

clear snow Feb 4, 2024, 2:40 AM

#

patent oar from vscode, in the base of your application

check your DM

#

first create your DB

#

and then migrate

polar harness Feb 4, 2024, 2:41 AM

#

Yes sir. But tbh, I'm only following this to be able to create DB on terminal

#

But I can just create it through phpmyadmin

#

Do I really still need to do this? (be able to create DB through terminal)

#

Will it be necessary for me in the long-run?

#

#

Tried it again and still stuck here 😭

#

Nvm

#

I just forgot the semicolon

#Mysql -u root error