mysql: cannot create database

deostroll · 07-28-2009, 02:09 PM

Hi,
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:

Code:

deostroll@deostroll-pc:~$ mysql -u mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 5.0.67-0ubuntu6 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database help
    -> ;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'help'
mysql> quit
Bye
deostroll@deostroll-pc:~$

EricTRA · 07-28-2009, 02:14 PM

Hi,

As the message states:

Code:

 Access denied for user ''@'localhost'

This user has no rights to create anything. Login as the MySQL root (NOT your root account at linux level!)

Code:

mysql -u root -p

It will ask you for a password. This is the password you choose when installing MySQL.

Kind regards,

Eric

deostroll · 07-29-2009, 02:11 PM

Still not working...

I did the installation a long time ago. I did somehow change the mysql's root login to "mysql". I do remember changing some config file. I am quite sure that I did not put a password for whatever login name I had assigned. Now I don't even remember where the config file is...!

EDIT:
I found the web page from where I learned to install mysql server. http://www.zolved.com/synapse/view_c...ySQL_On_Ubuntu. There is a section in my.cnf that goes like:

Code:

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking

Yeah I think I messed up there (see the underlined part)...I don't know what I did here or why i did it...?

kirukan · 07-29-2009, 02:26 PM

just type mysql and check whether can login to the mysql

deostroll · 08-04-2009, 01:17 PM

yes I am able to get to the mysql prompt...however I cannot create any database there...