473,396 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

MySQL and error 1044

I am new to MySQL and I have having a problem creating databases.
First some preliminaries...

Operating System - Windows XP Professional
MySQL Version - 4.0.20a-debug
Installed in "Services" to automatically start

I don't know if there's anything else need, if there is please let me
know. Regardless, on to my problem.

I have installed MySQL as described in the instruction but when I use
the following query to create a database called "working"

CREATE DATABASE working;

I recieve the following error:

ERROR 1044: Access denied for user: '@localhost` to database
'working'

____________

According to the manual this is an error MySQL cannot resolve the
hostname properly and suggests that creating a file called 'hosts'
with the following information will solve the problem:

127.0.0.1 localhost

Problem is it didn't solve the problem. Does anyone have any input on
how to get past this error? Where is this file supposed to be located
and what, if any, extension it should use?

von
In an intelligent dialog different does
not mean opposite.
Jul 20 '05 #1
0 2352

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Wolfgang Lang | last post by:
Hello community! I am successfully using mysql connections and operations in more than one php file. But when I want to use this in an included (required("header.inc.php")) php file but nothing...
14
by: KnockKnock | last post by:
Hi all, I have run into a bit of a problem. I recently setup mysql to run on a Debian Linux box I setup. I am by no means an expert on either linux or mysql. I know enough to just be dangerous....
0
by: Gilbert Wu | last post by:
Hi, I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS = Excel. However, it returned the following error when I tried to link = some Mysql tables from Access 2000: ...
4
by: Adam Smith | last post by:
I have a dedicated server running 'FreeBSD 4.9 STABLE' at a hosting site. They have done some default installations, presumably from the CVS ports package ??. Herein lies the problem, "I do not...
0
by: redfez | last post by:
I just installed mysql-max-4.0.20-sun-solaris2.8-sparc and ran the mysql_install_db script. I try to access a mysql db using a Lisp app that accesses the myodbc driver through our Lisp's odbc...
4
by: MLH | last post by:
I am having failures processing the following command and I wonder if you can tell me what I must do in order to have success. When I try to run source mysql_dump.sql.txt ==> it is a problem...
2
by: Don | last post by:
I'm new to MySQL and am having a frustrating time figuring out some of the tools. I'm getting ERROR 1044 when I try to execute the following sp. ------------------------------ DELIMITER $$ ...
6
by: frank78 | last post by:
Hi everyone, I am having a little bit of trouble backing up some mySQL tables. I've been trying to adapt a script I found on the internet at...
1
by: Steve Ametjan | last post by:
I've been trying to get MySQL-python to install on Leopard for the past couple of days, and I keep running into relatively the same error. I'm hoping that someone on this list will be able to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.