Sql databases
 

I still don't get it.

How can i make new databases in sql.
I can't even get to the sql prompt.

Please be more specific about what SQL datatbase you are using.

version
 

I am using Ver 11.18 distrib 3.23.51, for slackware-linux-gnu (i386).

As shown when i type mysql -V

Another Question
 

What does this mean and how do i get passed it:

Access denied for user: 'root@localhost' (Using password: YES)

### Show all databases
mysql> SHOW DATABASES;
### Create a database
mysql> CREATE DATABASE CURLYDB;
### Use a database
mysql> USE CURLYDB;
### Delete a database
mysql> DROP DATABASE CURLYDB;

Re: Another Question
 

IIRC the version of MySQL that ships with Slackware doesn't have the initial databases created. Take a look at http://www.mysql.com/doc/en/Post-installation.html I think you'll need to run the mysql_install_db script to create that database that holds the details of users like root. You might want to try specifying a blank password, or just use mysql without the -p option so it doesn't try to use a password. This password is completely seperate from the usual root password.

I take it that mysql is running? Can you see it in your process list? (ps -ef)

At the risk of saying RTFM - MySQL isn't that difficult to get running but its really worth carefully reading the available documentation, especially the bits on post installation setup and on user account creation.

HTH

Jamie...