LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-19-2002, 03:05 AM   #1
X11
Member
 
Registered: Dec 2001
Location: Brisie, Australia
Distribution: Slackware 8.1
Posts: 324

Rep: Reputation: 30
MySQL - access denied


I'm trying to get MySQL setup properly for mainly purpose of learning how-to use it.

But I seem to have a problem that I can't figure out; Every time on I type in the following:
Code:
mysqladmin -u mysql -p CREATE shop
and in the password for that user (Which I think I have done right???), it spits out the following message:
Code:
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'mysql@localhost' (Using password: YES)'
BTW: Here's a bit about my setup:
- I have compile MySQL version 3.23.51 from source on Slackware Linux 8.1.
- The options I have used for the configure script just include the path of the root
directory for the MySQL installation. eg.
Code:
./configure --prefix=/usr/local/mysql
NOTE: I Followed the stuff below from a file called INSTALL-BINARY under the directory called
Docs from where the source package was extracted to.
Code:
     
shell> groupadd mysql
     shell> useradd -g mysql mysql
     shell> cd /usr/local
     shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
     shell> ln -s mysql-VERSION-OS mysql
     shell> cd mysql
     shell> scripts/mysql_install_db
     shell> chown -R root  /usr/local/mysql
     shell> chown -R mysql /usr/local/mysql/data
     shell> chgrp -R mysql /usr/local/mysql
     shell> chown -R root /usr/local/mysql/bin
     shell> bin/safe_mysqld --user=mysql &
 
Old 08-19-2002, 06:51 AM   #2
j-ray
Senior Member
 
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,532

Rep: Reputation: 132Reputation: 132
i donīt know whether or not the mysqld is already started.
if not i would cd into the mysql directory and run
./bin/safe_mysqld start or
./bin/safe_mysqld mysql&
or sth like that (i donīt know exactly)
if itīs running you can log in
'mysql -u mysql -p;'
this should open a dialog where u fill in your password->
then u can
mysql%: create database yourdb;
mysql%: use yourdb;
create table...

or
log in as root
mysql -u root -p
and create users dbs and tables within mysql
p.s.: i doubt itīs a good idea to call the user 'mysql'. think about that.
so if iīm wrong post the error message u receive.
cheers, jens
 
  


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
MySQL access denied newlinuxnewbie Linux - General 3 10-25-2005 05:42 AM
MySQL: 'access denied for user' turbo_acura Linux - General 1 10-20-2004 09:34 AM
MySQL: Access denied error Raptor Ramjet Slackware 5 02-22-2004 09:07 AM
MYSQL access denied for user c0c0deuz Linux - General 1 03-18-2003 03:44 PM
MySQL access denied problems ?? huno Linux - General 1 05-16-2002 11:30 AM


All times are GMT -5. The time now is 02:50 PM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration