LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 04-09-2004, 06:11 AM   #1
chinaundead
Member
 
Registered: Feb 2004
Location: UK
Distribution: Mandrake 10 Official
Posts: 123

Rep: Reputation: 15
can to get access to mysql from a 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-09-2004, 07:32 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
You should read the documentation at www.mysql.com in which they explain the process of upgrading and they also explain the basic fundamentals of adding users, using mysql, etc.
 
Old 04-09-2004, 12:36 PM   #3
chinaundead
Member
 
Registered: Feb 2004
Location: UK
Distribution: Mandrake 10 Official
Posts: 123

Original Poster
Rep: Reputation: 15
Hi,

I know how to add user or something in mysql. I mean in my linux user account, I can not get access to mysql

[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)

any help, thank you!
 
Old 04-09-2004, 01:55 PM   #4
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Quote:
Originally posted by chinaundead
Hi,

I know how to add user or something in mysql. I mean in my linux user account, I can not get access to mysql

[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)

any help, thank you!
Are you trying to connect remotely or locally? If your root, try just typing mysql and then you can update/edit your user(s) information, etc. Is mysql even running? Have you tried:

mysql -h hostname -u(user) -p(password)

Notice the no spaces for -u and -p !

More details please, your first post came off as if you could connect to it with what you posted, but couldn't connect using a regular user, etc.
 
Old 04-09-2004, 07:56 PM   #5
chinaundead
Member
 
Registered: Feb 2004
Location: UK
Distribution: Mandrake 10 Official
Posts: 123

Original Poster
Rep: Reputation: 15
when I login as a root in my linux, I can get access to mysql:
[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;


But when I login as a normal user, I can not get access to mysql,
[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)

I am connecting to mysql locally.

Cheers!
 
  


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
Can not get access to mysql by normal user chinaundead Fedora 3 10-27-2010 02:33 AM
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
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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:27 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