Welcome to the iTechForums.
If this is your first visit, be sure to check out the
FAQ by clicking the link above.
You may have to
register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
|
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 1
Members:
Number of Users Online:
Welcome to our newest member, |
|
 |
05-15-2008, 11:01 AM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 8
|
|
MySQL commands via console.?
I have a mysql server ran on Ubuntu, I use phpmyadmin to manage the mysql and that works fine. But I SSHed into my server and wanted to try to manage the database via the console window and couldn't get it to work. Any one know what the problem is? I've copied my input/ output so you can see what the error is.
chad@curtisdt:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.0.38-Ubuntu_0ubuntu1.1-log Ubuntu 7.04 distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CONNECT blog;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Connection id: 41
Current database: blog
mysql> select * from blog;
ERROR 1146 (42S02): Table 'blog.blog' doesn't exist
mysql>
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
All times are GMT. The time now is 11:24 PM.
