LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices


Reply
  Search this Thread
Old 02-11-2003, 09:32 AM   #1
CurlyMo
LQ Newbie
 
Registered: Feb 2003
Posts: 26

Rep: Reputation: 15
Unhappy 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.
 
Old 02-11-2003, 09:42 AM   #2
AltF4
Member
 
Registered: Sep 2002
Location: .at
Distribution: SuSE, Knoppix
Posts: 532

Rep: Reputation: 31
Please be more specific about what SQL datatbase you are using.
 
Old 02-11-2003, 10:00 AM   #3
CurlyMo
LQ Newbie
 
Registered: Feb 2003
Posts: 26

Original Poster
Rep: Reputation: 15
version

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

As shown when i type mysql -V
 
Old 02-11-2003, 10:13 AM   #4
CurlyMo
LQ Newbie
 
Registered: Feb 2003
Posts: 26

Original Poster
Rep: Reputation: 15
Another Question

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

Access denied for user: 'root@localhost' (Using password: YES)
 
Old 02-12-2003, 04:00 AM   #5
AltF4
Member
 
Registered: Sep 2002
Location: .at
Distribution: SuSE, Knoppix
Posts: 532

Rep: Reputation: 31
### 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;
 
Old 02-12-2003, 04:31 AM   #6
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 47
Re: Another Question

Quote:
Originally posted by CurlyMo
What does this mean and how do i get passed it:

Access denied for user: 'root@localhost' (Using password: YES)
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...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Default databases in Postgre SQL redhatrosh Linux - Software 6 11-18-2005 06:33 AM
limiting users sql databases amadkow Linux - General 1 08-09-2005 11:05 AM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 02:20 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 05:07 PM
Databases frankyboy4 LQ Suggestions & Feedback 1 08-09-2002 01:27 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - General

All times are GMT -5. The time now is 08:07 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration