Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Sql Helpful Websites


  • Please log in to reply
8 replies to this topic

#1 marjon76

marjon76

  • Members
  • 9 posts
  • OFFLINE
  •  
  • Local time:11:29 PM

Posted 15 July 2008 - 08:48 PM

Hi guys,
Hope you're all doing well.
I've recently started learning SQL- mysql and sqlserver
Ive been spending hours finding sites that would have good examples of different commands.
I know about sqlserver.com, but it really hasn't been of much help.
So I'd greatly appreciate any suggestions, any good tutorials, websites etc.
I think I spent 3 hours at least trying to find the command for logging into mysql from
windows command line and going directly to a database.
Still not sure if I did it correctly.
mysql -u -p databasename?


Thank you.
M

BC AdBot (Login to Remove)

 


m

#2 Axephilic

Axephilic

    MRU Graduate


  • Members
  • 224 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Wisconsin, US
  • Local time:12:29 AM

Posted 15 July 2008 - 09:15 PM

Hi and welcome to BC!

Are you also going to learn PHP? That usually goes with MySQL in a web environment. :thumbsup:

Here is good tutorial for MySQL. It is what I used to start. http://www.tizag.com/mysqlTutorial/

Regards,
Adam
Proud to be a Graduate of Malware Removal University - I am a member of:
Posted Image Posted Image

If I helped you, please consider a donation: Posted Image

#3 groovicus

groovicus

  • Security Colleague
  • 9,963 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Centerville, SD
  • Local time:12:29 AM

Posted 15 July 2008 - 09:22 PM

Try this:

mysql -u username -p

Then when prompted, type in your password. Did you try using the Mysql website?

That usually goes with MySQL in a web environment


Umm, no, not really. :thumbsup:

#4 Axephilic

Axephilic

    MRU Graduate


  • Members
  • 224 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Wisconsin, US
  • Local time:12:29 AM

Posted 15 July 2008 - 09:31 PM

Umm, no, not really. ;)


I was just kidding? :thumbsup: Not really, but now I kinda feel dumb. The only time that I've used MySQL in a web environment, I've used PHP. I guess I need more experience with it, huh? ;)
Proud to be a Graduate of Malware Removal University - I am a member of:
Posted Image Posted Image

If I helped you, please consider a donation: Posted Image

#5 marjon76

marjon76
  • Topic Starter

  • Members
  • 9 posts
  • OFFLINE
  •  
  • Local time:11:29 PM

Posted 16 July 2008 - 11:39 AM

Thank you guys for your responses.

mysql -u username -p <--- this is the command to log into mysql, but I was trying to go to a database
on mysql directly from the command line. For instance the database called stuff.

mysql - u username -p stuff <-- I'd like to try this out to see if it works but I don't know how to get to the
command line C:\
run cmd takes me to C:\Documents and Settings\Marjan

I'm sorry guys, I'm a biology major just getting into the field of computers so just learning how to use my
computer as well.

Thank you

M

#6 groovicus

groovicus

  • Security Colleague
  • 9,963 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Centerville, SD
  • Local time:12:29 AM

Posted 16 July 2008 - 12:02 PM

You are going to have to find where Mysql is installed on your computer, and provide the full path, ie: c://some directory/mysql -u username -p stuff

#7 malonso

malonso

  • Members
  • 2 posts
  • OFFLINE
  •  
  • Local time:02:29 AM

Posted 16 July 2008 - 09:13 PM

If you are just learning, your best bet may be to use the MySQL GUI tools . I know I will probably get flamed for telling someone to use a GUI but I've found that starting this way can get people to become more comfortable with MySQL quicker than they might have otherwise.

#8 marjon76

marjon76
  • Topic Starter

  • Members
  • 9 posts
  • OFFLINE
  •  
  • Local time:11:29 PM

Posted 18 July 2008 - 01:45 AM

Ok, Thank you guys.
Your advice is much appreciated :D

Oh and I found out that I'm using a mysql server from a friend which is why I don't have it on my computer.
I should note that I'm also new to the computer field as well, so I apologize if my questions sound a bit "stupid" hehe.

M

#9 groovicus

groovicus

  • Security Colleague
  • 9,963 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Centerville, SD
  • Local time:12:29 AM

Posted 18 July 2008 - 09:00 AM

Your questions are not stupid, but we do need all of the information. Trying to log into mysql on a remote system is a completely different process. You first have to get a shell of some sort on the server (command line access). Your friend should be able to tell you how to do that. Then the process is exactly the same as I stated above.

Or you could just install mysql on your own system and play with it there.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users