1) Could someone please explain in detail the following privileges that were added in 4.xx ? These privileges are in the mysql.user table Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv ...
i got locked out of my database, i can recover my tables and minial data using scripts, but when i tried to create a new account / update root password so that i can login again, it said mysql.user table doesn't exist. now, when i say $ mysql i get ERROR 1045 Access denied for user 'root'@'localhost ...
You know how when you are really tired, and working on autopilot you tend to do stupid things? Well, today, I managed to drop the mysql.user table. I am running this instance under windows with XAMPP. It does have the perl script mysql_install_db.pl in xampp\mysql\scripts, however when I try to exec ...
About year ago i migrated from 3.x series server to 4.0 server and about 3 months ago to 4.1 server. First i did notice anything strange, but some day i wanted create new user. And because the username was longer than 6 char i noticed that mysql.user table has somehow got completly strange structure ...
I managed to log myself out of mysql totally. then, i discovered that i don't have a mysql.user table. how can i recreate the table and other dictionary / mysql system tables ? once, i have that, i can probably get back my data if i can login to mysql again. ...
I tried two different methods, but each of these statements not only fails, but kills the MySQL process as well. What am I doing wrong???? The trigger is designed to take a user added to the mysql.user table, with '%' designated as the host, and create another identical user with 'localhost' as the ...
I am working on 3 servers trying to configure them the same. The production box was set up differently then the rest. There are sym links and an older version of MySQL on the box in the usr/local/mysql-standard 4.... directory. There is a sym link from /usr/local/mysql to /mysqldatabases/opt/mysql/m ...
Please please help me. I have tampered the user table by adding an extra column and I cannot start the mysql client now. I start the client and enter the password for root - it just closes down and I cannot use my project now. Is there a way I can replace the users table? I do not want to reinsatll ...
I have just installed XAMPP (latest 1.7.7) on win7 and I am wanting to set user privileges on MySQL. I have logged into phpMyAdmin with user Root (it won't let me use root as I expected) and tried to change the password but it gave me a "can't find any matching row in user table." So I loo ...
I have been trying to find the answer to this question. In doing maintenance on the user table, I noticed that there was a user that had an exclamation point (!) as their password. Does anyone know what this is? Even a single character produces an encrypted password greater than 20 characters. The v ...
We moved from Mysql 3 to Mysql 5. The exact one : 5.0.77. In the past, (4.1.20), we had a database called mysql. In that DB, we could manage the overall properties a the users, and detailed parameters. Now, in the 5.0.77. version, we don't have that DB anymore ! We knew it, because there is a new fa ...
I just managed to have a cluster running and read that to authenticate the usual mysqld-server authentication is used. Assuming I would have a 3 mysqld's then I would have to maintain somehow 3 "mysql" tables. I would rather have the mysql table in the NDB instead of the default (ISAM?) St ...
ACTION = adding users on master REZULT = this users aren't in slaves can you give me some advices ? here is my setup OS = gentoo linux mysql 4.1.22 [master.cnf] bind-address = 0.0.0.0 log-bin = /var/lib/mysql/master-binary-log server-id = 1 max_binlog_size = 100M binlog-ignore-db = test [slave1.cnf] ...
I am trying to create a workorder database for my work and I'm currently starting on the admin portion of the system. I plan to have an include file that has the localhost,user,pass encoded with md5 hash and have the calling program use that to connect to the database. Once successful, on the web fo ...
ACTION = adding users on master REZULT = this users aren't in slaves can you give me some advices ? here is my setup OS = gentoo linux mysql 4.1.22 [master.cnf] bind-address = 0.0.0.0 log-bin = /var/lib/mysql/master-binary-log server-id = 1 max_binlog_size = 100M binlog-ignore-db = test [slave1.cnf] ...
ok, since i was new to PHP i saw this code and it all seemed to work in regards to login/security<?phpif (!isset($_SERVER['PHP_AUTH_USER'])) {//authenticateheader('WWW-Authenticate: Basic realm="Delmar"');header('HTTP/1.0 401 Unauthorized');echo 'You need to login to use this system. Pr ...
I have a question to the user management in mysql. I have two users root and test. Both have set a password. But the user test can logged in mysql without a password. Whereas the user root can't logged in without password. The password for both are set, I can see it in the mysql.user table. And as h ...
there, i am doing a project and i want to do the following. I have a MySQL user table in place where once the users register they are added to the table. Now i want to do the following, i want the user to register which will ofcourse add their details to the database table called "users" i ...
I have figured out how to have users create accounts (via a mysql user table... for authentication), with passwords and they are inserted into the mysql databases as encrypted passwords... viaINSERT INTO table (upass) VALUES (password('$upass'))"; BUT in my script to send the user their passwor ...
For some reason the mysql database does not contain any tables; How do i restore the default user table? I tryed to reinstall mysql: yum remove mysql httpd php php-mysql mysql mysql-server yum install mysql httpd php php-mysql mysql mysql-server service mysqld start [root@localhost] ~ : mysql -u roo ...
I accidentally dropped my USER table... and i have no backup :( Of course, mysql doesn't start anymore... Is it possible to repair? I run mysql 5 on a gentoo linux. Thanks for your help! Franck EDIT: Solved.Edited 1 time(s). Last edit at 02/13/2008 03:37PM by Franck Lambo. ...
After migrating 25 databases into a new mysql instance (mysql_1), one of my developers ran a third party script in the mysql_1.mysql database. This has re-created the user table. This is a brand new install and there is no backup of the mysql DB. I was thinking of installing another instance of mysq ...
I accidently removed the "user" table in mysql using Phpmyadmin and now I can not access any of my databases or their contents. I now get user "denied to user: 'root@localhost' for table 'ZYZ'.Is there anyway I can recover or add a new user table. It is not allowing me. ...
After I have installed mySQL 4.1 on WinXP, what should the 'user' table look like? Viewing the user table in the command line client, I am seeing two users: both @localhost, one of them root@localhost and the other does not specify a user. I am able to connect to MySQL in php as long as I don't spec ...
I am trying to backup a mantis db on another machine. Both machines are running on Fedora Core 11. Here's what I did: 1. Create the backup db $ mysqladmin create bugtracker 2. Create the user using MySQLAdministrator 3. Copy the following files from the source to backup machine: $ copy /nfsmount/var ...
Just installed a MySQL on my server but for unknown reason im not able to set a root password. Got access denied messages. CentOS 5.4 - 2.6.18-164.9.1.el5PAE MySQL Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 # yum install -y mysql mysql-server php-mysql # service mysqld ...
I've been having some trouble with privileges for users I've set up to allow from host "%"; while this permits them to connect from any other *remote* host, it seems not to match programs connecting from localhost. For example, if I GRANT SELECT ON *.* TO 'FOO'@'%' then I can read any tabl ...
Running MySQL 5.0.45 on an Centos system and a 6GB innodb database, I'm having problems with user, db, and sometimes proc tables in mysql database becoming corrupt. They're usually fixable with myisamchk -r, but other times it fails and the user table is unreadable. At that point, I restore the mysq ...
this looks long, but if you know your stuff, PLEASE read through.. i beg of you! :)i'm beginning to build a Songs & Shows database for my website (http://www.thebreakfast.info) (a fan site for the band, 'the breakfast') with PHP & MySQL. i'm pretty new to PHP, though i'm familiar with a lot ...
After I have installed mySQL 4.1 on WinXP, what should the 'user' table look like? Viewing the user table in the command line client, I am seeing two users: both @localhost, one of them root@localhost and the other does not specify a user. I am able to connect to MySQL in php as long as I don't spec ...
Hello, I installed LAMP on a clean ubuntu jaunty server and when I try to login to mysql I get wrong password error, when I run with --skip-grant-tables and check out the users table, its empty apart from 'debian-sys-maint'... anyone know how to add a root user?Ubuntu 9.04 / JauntyInstalled lamp usi ...
i accidentally change HOST (from 'localhost' to 'domain') in user table, mysql database, i try to run sql.exe in bin but also cannot connect to mysql server using mysql.exe -h domain or 'localhost' , so i cant reset host from there, any expert pls advise meEdited 1 time(s). Last edit at 08/16/2011 0 ...
i was deleting host % from user but accidentally deleted all users from user table. then i ran command grant all on *.* to root@localhost identified by 'pass'; now i can access the database with putty but i want to add another user but when i try to use above command i get error 1045 (28000) access ...
i'm in despair ... I got a user table and wanna set specified attributes to each user (for example; userID 1 ; eyecolor(attributeKeyID?) = blue(attributeValueID) ; haircolor = blonde etc.) I can set the attributeKey translation within my language files, but i need a translation of the values in the ...
I am trying to create a table with a multiple primary and am getting errors . Here is my query. Please let me know what is wrong with this. Any help is greatly appreciated. Thanks in Advance Krishna mysql> create table user ( -> userid varchar(10) NOT NULL, -> ssn varchar(11) NOT NULL PRIMA ...
Good morning! I'm running a MySQL 4.0.23-server on my Ubuntu 5.04 machine. I have two problems with my mysql-server, and any help would be appreciated. :( The first problem is a hairy one: Tonight someone broke into my system and removed all privileges from my users except the debian-sys-maintainer. ...
I have problem with adding, updating and deleting users from my application. There is an internal table (to hold address etc.) and I also need to add users to MySQL. Everything seems to work except the "drop user" part. I'm not sure about the @'localhost' and @'%' but I think I have to add ...
Installed software/os:Win NT 4.0IIS 4.0PHP 4.3.1MySQL 4.1.1phpMyAdmin 2.5.6I'm wondering how I can hide phpMyAdmin access via a webpage to the mysql.mysql table....specifically the user table.I don't wan't anyone using phpMyAdmin to have access to the user table. I only want to control that db & ...
I am relatively new to php and mysql and here is what I would like to do. I have a mysql table with the curriculum vitae (CV) information of about 50 researchers. I would like each researcher to be able to edit and update his/her information. In order to do this I need to create a membership system ...
guys, I have been trying to create a table to store user information, and I always get the error 1064. If you guys could please help. Thanks. Here's the table and the results: mysql> CREATE TABLE 'users' ( -> 'id_user' INT(10) NOT NULL AUTO_INCREMENT , -> 'fname' VARCHAR( 128 ) NOT NULL , - ...
I built a Fedora 14 test system on VirtualBox for cacti and nagios. Webmin is also installed. After installing cacti, I am having difficulties accessing it via a browser on the localhost. Error messages point to a permission / authorization problem. Using Webmin I can see the cacti user and another ...
This will probably tick many people off as I'm using the beautiful Dreamweaver MX which has more code than hot dinners, however I'm wondering if someone can help me out here. I've got a web-site that will have different login areas in separate folders ie: domain.com/pics and domain.com/news and doma ...
I installed MySQL Admin on a MAC server that hosts a MySQL today for the first time. I tried to add select permissions on the mysql.users table for a particular user as we were getting an error in a web app on this user for not having select permissions. I didn't solve the problem. So I changed the ...
Hello, I want to change some entries in the database tabele mysql.user. The statement ist quite simple: update user set Grant_priv='Y'; I got the error message : ERROR 1036 (HY000): Table 'user' is read only How can I change that ? I work with MySQL Cluster 4.1.12 but this database is a MyIsam engin ...
I've just installed mysql on a mac running osx, but I'm having trouble doing anything with the user table after installation. Every time I try changing the password (it's still open for root and insecure) I get the message telling me the user table is read only.How do I change this so that I can set ...
i'm having a problem here that i have searched all over for the answer towards.. mysql is on a win 2000 server if that makes any difference.it seems that the user table is readonly, therefore i can't change the root password, add new users, etc..this is a bad thing.any suggestions on what to do? (to ...
I am a *newbie* in a sense that I have never had any hardcore education in Database design. I have done a ton of stuff working with PHP, Perl and MySQL. But I don't have much experience making my Databases good. Well, I am starting a new project and would like some input on what I think will be a pr ...
I have a MyISAM table named a_lien: $ ls -lh /var/lib/mysql/RM/a_lien* -rw-rw---- 1 mysql mysql 8.7K 2009-11-18 18:03 /var/lib/mysql/RM/a_lien.frm -rw-rw---- 1 mysql mysql 35G 2009-11-30 19:52 /var/lib/mysql/RM/a_lien.MYD -rw-rw---- 1 mysql mysql 7.5G 2009-12-01 12:24 /var/lib/mysql/RM/a_lien.MYI Th ...
I am relatively new to php and mysql and here is what I would like to do. I have a mysql table with the curriculum vitae (CV) information of about 50 researchers. I would like each researcher to be able to edit and update his/her information. In order to do this I need to create a membership system ...
How to lock a mysql record / table in php, when another user updating / selecting the same record. Please help me fast. ...