LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 07-02-2003, 08:59 AM   #1
wonderpun
Member
 
Registered: Aug 2002
Location: Geekland, Planet Earth
Distribution: Slackware 9.1
Posts: 323

Rep: Reputation: 30
Talking Problems with mysql 4.0.13


Hello everyone! Ok, I have a small problem with mysql. Well firstly I don't know how to stop it. Any suggestions? And well secondly, I run it as a user(mysql) and when I want to create a new database it always gives me an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Ok, it's the same if I try it from user and etc. Well I guess the best help would be if someone could point me to some good manual or tutorial. Thanks very much advance!
 
Old 07-02-2003, 09:15 AM   #2
pilot1
Member
 
Registered: Jun 2002
Location: USA
Distribution: Gentoo, Fedora Core
Posts: 408

Rep: Reputation: 30
I don't use MySQL, but it looks like MySQL is trying to connect to your computer as root, using the wrong password.

I'm not sure how MySQL is supposed to connect, but you probably need to tell it to connect as a different user.
 
Old 07-02-2003, 12:24 PM   #3
wonderpun
Member
 
Registered: Aug 2002
Location: Geekland, Planet Earth
Distribution: Slackware 9.1
Posts: 323

Original Poster
Rep: Reputation: 30
Ok guys. I almost sort it out, except that: I want to create a new database right? So I run:
mysql -u mysql
because when I run it with user root it gives me an error that I can't conect to the database. So. When I connect to the database I run:
CREATE DATABASE `kknd`;
And then I get an error:
ERROR 1044: Access denied for user: '@localhost' to database 'kknd'
Oofff.... I don't know what to do. My head hurts because all day I've been installing apache, php, SSL and trying to configure mysql. Help me out guys, why can't I create a database?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 02:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-07-2008 11:48 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
DBD::MySQL + MySQL install problems. Elleroth Linux - Software 4 03-24-2006 06:53 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 07:40 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration