473,379 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

login as user 'root' but do not have root privlages and mysql doesn't recognize root logged in

Hi gang:
I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0
to 4.1.10 and now when I login as root it doesn't show all the databases I
should have access to, nor it doesn't recognize me being logged in as root
(via CURRENT_USER().)

Here it is, line-by-line. Inline comments are denoted by '//'

err# uname -a
FreeBSD err.the_hostname.net 5.2-RELEASE FreeBSD 5.2-RELEASE #0: Sun Jan 11
04:21:45 GMT 2004 ro**@wv1u.btc.adaptec.com:/usr/obj/usr/src/sys/GENERIC
i386

// FreeBSD 5.2 -- MySQL was deinstalled and upgraded via the ports
collection.

err# mysql --version
mysql Ver 14.7 Distrib 4.1.10, for portbld-freebsd5.2 (i386)

// Mysql version 4.1.10

err# ps auxwww |grep mysql
mysql 42951 0.0 0.2 924 400 p0 I 7:46PM 0:00.01 /bin/sh
/usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/err.the_hostname.net.pid
mysql 42968 0.0 9.9 52968 23556 p0 S 7:46PM 0:08.07
/usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --pid-file=/var/db/mysql/err.the_hostname.net.pid

// MySQL is running as the user 'mysql' and loads the datadir
'/var/db/mysql'

err# ls -la /var/db/mysql/
total 28782
drwx------ 7 mysql mysql 512 Feb 22 19:47 .
drwxr-xr-x 8 root wheel 512 Feb 18 16:59 ..
-rw-rw---- 1 mysql mysql 8224 Feb 22 14:35 err.err
-rw-rw---- 1 mysql mysql 8292 Feb 22 19:47 err.the_hostname.net.err
-rw-rw---- 1 mysql mysql 6 Feb 22 19:46 err.the_hostname.net.pid
-rw-rw---- 1 mysql mysql 25088 May 16 2004 ib_arch_log_0000000000
-rw-rw---- 1 mysql mysql 5242880 Feb 22 19:46 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 May 16 2004 ib_logfile1
-rw-rw---- 1 mysql mysql 18874368 Feb 22 18:55 ibdata1
drwx------ 2 mysql mysql 1024 Nov 18 17:54 jaga
drwx------ 2 mysql mysql 1024 May 16 2004 mysql
drwx------ 2 mysql mysql 512 Jun 8 2004 projects
drwx------ 2 mysql mysql 512 May 16 2004 tempdb
drwx------ 2 mysql mysql 512 Jun 3 2004 test

// The user 'mysql' owns /var/db/mysql and the contents within. This is the
data directory for MySQL.

err# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.10

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

// I login as the user 'root'

mysql> show databases;
+----------+
| Database |
+----------+
| test |
+----------+
1 row in set (0.00 sec)

// None of the databases in /var/db/mysql (except 'test') show.

mysql> SHOW VARIABLES LIKE "datadir";
+---------------+----------------+
| Variable_name | Value |
+---------------+----------------+
| datadir | /var/db/mysql/ |
+---------------+----------------+
1 row in set (0.00 sec)

// The path is as expected.

mysql> SELECT CURRENT_USER();
+----------------+
| CURRENT_USER() |
+----------------+
| @localhost |
+----------------+
1 row in set (0.00 sec)

// I login as 'root' but it shows the current user as "@localhost" ?

Something isn't right. Any ideas?
Thanks,
Jul 23 '05 #1
0 1851

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

Similar topics

10
by: TheDD | last post by:
Hello every body, i have to do a news system wich use php/mysql. i need 3 accounts: * a 'reader' who doesn't need to log in to read the news * a 'writer' who can write news in a pending news...
3
by: XP | last post by:
I am having problems with the blow page. I have a login page where I enter the userid and password. This then connects to this page. If I enter the userid and password correctly, it prints...
4
by: XP | last post by:
I am having problems with the blow page. I have a login page where I enter the userid and password. This then connects to this page. If I enter the userid and password correctly, it prints...
4
by: 23s | last post by:
I had this problem in the past, after a server reformat it went away, and now after another server reformat it's back again - no clue what's doing it. Here's the flow: Website root is public, no...
2
by: pv | last post by:
Hi everyone, I need help with following scenario, please: Users are accessing same web server from intranet (users previously authenticated in Active Dir) and from extranet (common public...
9
by: Ben | last post by:
Hello, I'll bet this has been asked a million times but I can't seem to find a thread that gives the clear example I need. This PC has MySQL and IIS configured and running. The MySQL database is...
1
by: mattsql22 | last post by:
I just installed Red Hat Enterprise 5, along with MySQL. I have run mysql_install_db and I can see the mysql folder that contains the 'mysql' database with the users. Unfortunately, I can't login...
9
by: Josh | last post by:
I run a Joomla website and am familiar with php in some but not all aspects. Currently I am trying to find some solutions related to session handling. Am I correct in saying that "login" is kept...
10
by: DavidPr | last post by:
When I logout as one user and log in under a different user, it opens with the last user's information. User 1 - Unsername: Davey Jones User 2 - Unsername: David Smith I log out from Davey...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.