473,396 Members | 1,834 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,396 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 1852

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...
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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.