LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Password
Fedora This forum is for the discussion of the Fedora Project.

Notices

Reply
 
Search this Thread
Old 04-09-2004, 05:29 AM   #1
chinaundead
Member
 
Registered: Feb 2004
Location: UK
Distribution: Mandrake 10 Official
Posts: 123

Rep: Reputation: 15
Can not get access to mysql by normal user


Hi,

I can not get access to mysql by normal user in my computer ( I can do it by root )

in the normal user's terminal, I type:

[wangjunwei@so-19661-x0 wangjunwei]$ mysql -h localhost -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

How can I fix it?

It seems my Fedora2 use mysql 3.23.58, because it says:
[root@so-19661-x0 lib]# mysql -h localhost -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> Use mysql;

How can I upgrade to mysql 4.0,?


Cheers!
 
Old 04-11-2004, 01:03 AM   #2
meonkeys
Member
 
Registered: Apr 2004
Location: Minneapolis
Distribution: Ubuntu
Posts: 45

Rep: Reputation: 15
Try logging in without using a password, like so:
Code:
$ mysql -u root
It's usually a good idea to create user accounts rather than logging in as the default (root without password). For information on user management in MySQL, see here:
http://dev.mysql.com/doc/mysql/en/Us...anagement.html

You can download version 4.0 of MySQL here:
http://dev.mysql.com/downloads/mysql/4.0.html
You want "Linux x86 RPM downloads". Install them all once you've downloaded them using the command 'rpm -Uhv MySQL*rpm'.
 
Old 04-11-2004, 12:20 PM   #3
chinaundead
Member
 
Registered: Feb 2004
Location: UK
Distribution: Mandrake 10 Official
Posts: 123

Original Poster
Rep: Reputation: 15
Hi,

I create a normal user in mysql named "wangjunwei", when I login in Linux as my root account, I can get access to mysql with my normal mysql account "wangjunwei".
[root@so-19661-x0 wangjunwei]# mysql -h localhost -u wangjunwei -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


But when I login my linux as my normal account, I can not get access to mysql database, do you know why?
[wangjunwei@so-19661-x0 wangjunwei]$ mysql -h localhost -u wangjunwei -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
 
Old 10-27-2010, 02:33 AM   #4
visitashu
LQ Newbie
 
Registered: Jan 2006
Location: Bangalore : INDIA
Distribution: Ubuntu, RedHat, Gentoo, Linux Mint, Arch Linux, Fedora
Posts: 26

Rep: Reputation: 0
Hi,

Have you done this "mysql_enable=YES" in your configuration file ?
 
  


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
Not Able to Access NTFS as normal user rob0t Slackware 6 09-21-2005 06:57 PM
Getting hardware access as normal user Zotty Programming 2 02-01-2005 11:13 AM
can to get access to mysql from a normal user chinaundead Linux - Software 4 04-09-2004 07:56 PM
getting access denied , when trying to access camera as normal user bennythepitbull Linux - Hardware 2 11-04-2003 02:30 AM
cdrom normal user access N|ghtwo|f Linux - Software 1 07-08-2003 07:05 PM


All times are GMT -5. The time now is 12:57 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration