| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 108122 | 2010-03-15 00:14:00 | mysql | Buff_K (691) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 867284 | 2010-03-15 00:14:00 | Hello . I'm trying to practise my sql which I am able to do at school, however I am having trouble running it at home . I have a . sql file and all I wish to do is query it . I have downloaded mysql workbench and installed it successfully . It opens up into the Workspace screen whereby I click on Open Connection to start querying . Hostname i enter as localhost and username root . No dice . I haven't started the sql server if I need to . I don't know where or how to . The teacher at schools not overly helpful at all, so any help would be much appreciated . Thanks |
Buff_K (691) | ||
| 867285 | 2010-03-15 00:40:00 | I have a .sql file and all I wish to do is query it.You can't query a SQL file - a SQL file *contains* queries. If this SQL file defines a database structure / data, you'll need to actually import it into the database before you can do anything with it. ...whereby I click on Open Connection to start querying. Hostname i enter as localhost and username root.This means you're trying to connect to a database server running on the same machine as SQL workbench. I haven't started the sql server if I need to. I don't know where or how to. Have you even installed MySQL on this machine? Note that MySQL Workbench doesn't include MySQL as part of its installation - you'll need to download and install that separately. |
Erayd (23) | ||
| 867286 | 2010-03-15 00:53:00 | Hi Buff Try the mysql forums........ forums.mysql.com |
Scouse (83) | ||
| 1 | |||||