RichB

OK, mysql novice here, I have a linux server, i know the admin username and password and know the su password.
Want to create a database but always get a :
ERROR 1044: Access denied for user: '@localhost' to database 'MYTEMP'

Who should I be logged on as?

Any good quick start guides for SQL not pages and pages of stuff. I just want the real quick start guide...

Lee

on a first time install of mySQL you have a database called mySQL and a demo one (called test or something - can't remember)

mysql -u root -p

and then enter the password to get on as root.

create database xxxx ;

use xxxx ;

all from memory (poor) 'fraid - I use mascon from www.scibit.com

mparsonage

The MySQL privileges system is completely separate from the host system's privileges. Therefore, it doesn't matter who you are logged in as.

There is no default password for root - so you can just connect using 'mysql -u root'. Obviously you'll want to change this:

USE mysql;
UPDATE user SET Password=PASSWORD('newpassword') WHERE user='root';
FLUSH PRIVILEGES;

If you have forgotten the root password, you can restart mysqld with --skip-grant-tables to change the password.

I'd recommend using phpMyAdmin (if you've got PHP) to access the DB.

mparsonage

Forgot the tutorial link :

Introduction to MySQL: A MySQL Tutorial

RichB

Thanks guys will give it a try.

Scoobynet never ceases to amaze me at how quick you can get an answer to almost any question.