SQL Password

[fallenapples]

I cannot figure out the correct prompts for cm in SQL I have tried -h -p -u and other variations. Am I putting in the correct credentials? Is my host name localhost? On phpmyadmin it tells me I am user root@localhost. Please help!

 

[iFargle]

mysql -u <username> -p <password not required, will prompt if left empty>

So it would just be
mysql -u root -p

and it will prompt for password

 

[fallenapples]

Do I have end it with a semi-colon, because if I don't it just gives me the prompt ->

 

[carnageX]

Just an FYI, SQL != MySQL

Make sure you're referencing the correct environment .

 

[iFargle]

mysql is best sql!

 

[carnageX]

mysql is best sql!

Meh, I've used both. I like SQL because of table-value parameters and SQL Server Management Studio (and the integration with Visual Studio ).

 

[Ornstein]

Meh, I've used both. I like SQL because of table-value parameters and SQL Server Management Studio (and the integration with Visual Studio ).

When you talk about "SQL" do you mean Microsoft SQL Server? SQL itself is a language, not a DBMS. Just to be pedantic.

 

[carnageX]

When you talk about "SQL" do you mean Microsoft SQL Server? SQL itself is a language, not a DBMS. Just to be pedantic.

Yes, when I said "SQL" I meant MS SQL Server and Transact-SQL .