Manish,
Manish Gupta wrote: > Hi all, > I am Manish from India and i am new to mysql. > > These are the steps that i had taken: > > 1. Installed MySQL 4.0.20d-Win....it came with a cd in a book i bought. > 2. Executed the winmysqladmin file from mysql/bin. gave it a username and > password. > 3. went to command prompt and the troubles started. > > Problem 1: when i type show databases, it only gives me one data base: test. > i read that it shud give me 2, test and sql. > > Problem 2: when i want to create database is shows: > mysql>create database music; > "ERROR 1044: access denied for user: '@localhost' to database 'music' > > can someone please help me. do yourself a favor: Do not touch version 4.0.20, just drop it and get something current. MySQL 4.0 is past its end-of-life, you will not get any upgrades (within the 4.0 series) for it. Investing any effort in it is waste, you should immediately get a current version and use it. The candidates are: - Of the 5.0 series: version 5.0.75 - Of the 5.1 series: version 5.1.31 or 5.1.32 All these are available as free downloads via http://dev.mysql.com/downloads/mysql/ As I don't know your book, I can't tell which 4.0-specific instructions it contains that need to be adapted to 5.0 or 5.1, but there will be some. Nonetheless, it should be much easier to use general instructions for 5.0 or 5.1 together with your book, than now do anything based on 4.0 just to realize you then want to upgrade. Also, bear in mind that 5.0 and 5.1 have not only lots of functional improvements over 4.0 but also fixes for several security-related bugs, you do not want to run MySQL without these. Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
