473,800 Members | 2,525 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

help mysql - cant do anything

Im rather new to Linux and my server has been running great, up until the
other day.

I was messing around with mysql through webmin in mandrake 9.2 and know I
cant do anything, not even create a database. I keep getting this message (
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')
and have no clue how to fix it. I have tried to reinstall the rpms that came
on the mandrake 9.2 cds and I still get the same messages.

If anyone could help it would be greatly appreciated

thanks

Bill Friend
bf*****@wi.rr.c om
Jul 20 '05 #1
2 2057
William Friend wrote:
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')


You are trying to create a database with a user '' which dosn't have
prileges to create databases. By default, only 'root' has this privilege.

Try logging in as a root user.

mysql -u root

Or if you have password for root (mysql root is different from Linux
root and they don't share the password)

mysql -u root -p

If this fails, you can try resetting the password for root and try again.
Jul 20 '05 #2
Like they say in electronics trouble-shooting:

"Do some swapping"

Get to another machine and install and get MySQL running on a Windows
machine. If that works, then you know Mandrake OS (I don't know much
about Unix/Linux) is preventing you from accessing your hard drive.
Maybe security or accesss issues???
Good Luck!
"William Friend" <bf*****@wi.rr. com> wrote in message news:<Z5******* **********@twis ter.rdc-kc.rr.com>...
Im rather new to Linux and my server has been running great, up until the
other day.

I was messing around with mysql through webmin in mandrake 9.2 and know I
cant do anything, not even create a database. I keep getting this message (
DBI connect failed : Access denied for user: '@localhost' to database
'mysql')
and have no clue how to fix it. I have tried to reinstall the rpms that came
on the mandrake 9.2 cds and I still get the same messages.

If anyone could help it would be greatly appreciated

thanks

Bill Friend
bf*****@wi.rr.c om

Jul 20 '05 #3

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

Similar topics

0
1333
by: john townsley | last post by:
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:\mysql. I type the command to start the mysql server c:\mysql\bin\mysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
3
1333
by: john townsley | last post by:
I cant get mysql to run on my winXP computer. I have downloaded it and installed , unzipped and run setup.exe and placed it in c:\mysql. I type the command to start the mysql server c:\mysql\bin\mysqld --console It opens the console and then the console shows some inoDB commands and the console hangs. I followed the mysql manual and i cant find the answer there is no command prompt and nothing...how do I run mysql?
6
22539
by: Matt Liverance | last post by:
I REALLY dont want to switch to oracle :( but I cant get these tables working any faster. I've got 2 dedicated servers, each with a slave, all run 32gig 15k rpm raid 5 on u320 perc raid cards, dell 2600/4600's with single channel backplanes (new ones will have dual channel) All have 2 gig of ram, but I've never seen mysql use more than 300mb of ram.
1
4514
by: linux | last post by:
Sorry if this is a really dumb question. I am trying to connect to our remote MySQL server (which is running just fine). I have a perl script which worked just fine on my other Fedora 4 box (all servers are Fedora 4 with latests updates). The one that worked fine it down and I cannot compare anything against it (it was a client also). My problem is, when I try to connect to the server I get:
6
3140
by: ancelotp | last post by:
hi, i'm new to sql i'd appretiate if someone would helpme out with this doudt i have CODE: CREATE TABLE entry ( uno int(6) NOT NULL auto_increment, fname varchar(30) NOT NULL, sname varchar(30) NOT NULL, email varchar(30) NOT NULL ,
4
4104
by: NancyJ | last post by:
Currently we have a database with a main table containing 3 million records - we want to increase that to 10 million but thats not a possibility at the moment. Nearly all 3 million records are deleted and replaced every day - all through the day - currently we're handling this by having 2 sets of tables - 1 for inserting, 1 for searching. A block of records (10k - 1 million) (distinguished by a client identifier field) happen on the...
17
2039
by: so many sites so little time | last post by:
all right so the script is pretty simple it goes it retrives what the id of the post is and it lets you edit it well no it doesnt. now if you go to www.kirewire.com/pp2/index/php you will see a number 1 that is the value of collumn home_id which is set to auto increment ect ect but this script which gets the id of home_id of a row and lets you edit it does not work for somereason...
11
1346
by: wireshark | last post by:
does anybody have try ? i cant connect with mysql in that server. event i was ask the support. dont give me a good solution. i was have twice answer with same answer,and i have do anything that give me.still cant connect. anybody know? what webserver that's free n really good to try? i was a newbie in PHP. thanx for all
1
2774
by: DarkGiank | last post by:
Hi, im new to csharp and im trying to create a class that can change the application database without no rewriting all connection code... but cause some reason it is not working... it tells me that im not creating the object but im doing it,,, please help im a newbie to c# using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SQLite; using MySql.Data; using MySql.Data.MySqlClient; using...
0
10287
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10260
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9099
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7588
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6826
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5479
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5616
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4156
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2956
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.