Al Sparks <[EMAIL PROTECTED]> wrote on 13/02/2006 16:11:49: > Basically, I'm new to mysql (or to any database for that matter). > > I have an old version installed on my linux machine. I thought, as a > learning exercise I'd take 2 files (tab separated tables) load them > into mysql and then merge or join them. > > So what are the steps? The first thing I tried was to create a > database with > mysqladmin create MACARP > and the error I get is > CREATE DATABASE failed; error: 'Access denied for user: > '@localhost' to database 'MACARP'' > > A similar attempt to create a user ended similarly. Can I get some > hints?
When your system was installed, it was installed with security turned on (which is definitely a wise thing to do). MySQL security is a bit like linux secutiry, in that there is a user called root who is usually omnipotent, and other users with lesser rights, and you cannot do anything unless yuou have the appropriate rights. However, it is not the same as linux security - your linux user name and your MySQL user name are different entities, not the same unless you choose to make them so. I would reccommend that you try and find out the root password for your system from whoever installed it. If not, and you think that no data on the system is valid, de-intall MySQL, remove the data directory (which also contaisn the security data), and re-install. Alternatively, the MySQL installation usually sets up a database imaginatively named "test" with wide rights, so that you could run you experiments within database test. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]