Resetting Permissions On Windows
If I am using Win98 SE (yes yes, I agree...), will underneath still
work:
http://www.mysql.com/doc/en/Resetting_permissions.html ?
I have tryed to follow above and similar advices, but haven't had a
lot of luck.
I will try again soon, but I was wondering wether there was an easier
way (e.g. if there was a "reset" command I could run that also works on
Win98). Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Resetting Root Password On Windows
I am trying to change the root password on mysql following the docs at http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-windows When I run the command, it just returns a solid cursor the next line after <GPL>. I have let it sit for 5 mins and it still never returns anything back. I can look in my Processes and see that mysqlsd-nt.exe is running along with the website connected to the database is able to get the data. When i try to connect to the root username thru SQLyog I get the error Access denied for user 'root@localhost'. Anyone have any ideas? Output from dos prompt .....
View Replies !
Resetting The Root Password On Windows
I am trying to reset my root password (because I forgot it!). I have followed the instructions in the manual for this (http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html) but I keep getting the following error: C:>"C:Program FilesMySQLMySQL Server 5.1inmysqld.exe" --defaults-file="C: Program FilesMySQLMySQL Server 5.1my.ini" --init-file=C:mysql-init.txt --co nsole 090303 2:17:06 InnoDB: Started; log sequence number 0 46409 090303 2:17:06 [ERROR] C:Program FilesMySQLMySQL Server 5.1inmysqld.exe: File 'C:mysql-init.txt' not found (Errcode: 2) 090303 2:17:06 [ERROR] Aborting 090303 2:17:06 InnoDB: Starting shutdown... 090303 2:17:08 InnoDB: Shutdown completed; log sequence number 0 46409 090303 2:17:08 [Warning] Forcing shutdown of 1 plugins 090303 2:17:08 [Note] C:Program FilesMySQLMySQL Server 5.1inmysqld.exe: S hutdown complete The MySQL service was stopped before running this command. I can assure you that there is a file 'C:mysql-init.txt' with the text described in the manual. Any idea what's going on?
View Replies !
Resetting A Field Value
How do I reset the values of a specific field with phpmyadmin to 100? I have a priority field for each link on my community search engine, each one with a different weight. Well, I would like to reset the number to 100, for example, so that each link has a priority of 100. As it stands now, some are 10, some are 0, 1, etc. etc. Once I reset it, I'm going to change the values of some of the records manually.
View Replies !
Resetting The Max_questions Value
I'm using phpBB with a MySQL database, obviously. I set the board up and launched it, but within a couple of hours, I got an error message, saying Website Critical Error Could not query config information DEBUG MODE SQL Error : 1226 User 'alterbri' has exceeded the 'max_questions' resource (current value: 50000) SELECT * FROM phpbb_config Line : 229 File : common.php . I know that I need to reset the max_questions value, and I know how to as well, but my question is - and this is a stupid one - where in the world do I change the data? In which file is the max_questions code implanted, where i change the value from 50000 to 0?
View Replies !
Resetting Auto_increment Value
how do i reset the auto_increment value of a table back to 1? I truncate and re-insert data back into a table every 2 seconds. So after a few hours the "wellID" number gets maxed out and i get a duplicate ID number error When I do that initial truncate i need to reset the auto_increment back to 1 so that it virtually wont max out.
View Replies !
Resetting Auto_increment Value?
Say you add 3 rows to a table, the auto_increment value will be set to 4 (for the next record)... then you delete record number 3, but auto_increment value is still 4. Is there a function in MySQL that reshuffles the auto_increment value? Will
View Replies !
Resetting All Collums To 0
large table with lots of collums and I want to run a query which sets alll the collums to = 0. Is there an easier way to do this other than typing out each individual collum. i.e. UPDATE `table` SET `col1` = '0', `col2` = '0' ... etc Is there a quicker way than above?
View Replies !
Resetting The Root Password
Having a browse through Paul Dubois's book, MySQL (ISBN 0-7357-1212-3), I came across a section in which he describes how to reset the root password: 1. Shutdown the server by issuing a KILL under Unix or stopping the system service under Windows. 2. Restart the server with the --skip-grant-tables option which allows you to connect with no password and all privileges. 3. Reset the root password. Given that the person first has to have operating system root or administrator access to shutdown the server, wouldn't this qualify as a security hole in cases where the OS root doesn't own the database, for example, on shared machines.
View Replies !
Resetting Auto-increment
Is there any way to leave a table in place, delete all the rows and reset the autoincrement pointer? Or do I need to drop and recreate the table structure to make that happen?
View Replies !
Resetting Permission/privilege
I accidentally changed the privilege of the root user for the mysql DB to 'N' for all!! Now when I try to run any query on any of the table I get the: Quote: mysql> select * from users; ERROR 1044: Access denied for user: 'root@localhost' to database 'mysql'
View Replies !
Resetting Max_questions Field?
I have set up Apache 2.0.52 on Win2k box. I have installed MySQL 4.1.9 I have installed MySQL Administrator 1.0. PHP is installed as well, though I dont think that matters for this, or does it? everything is default, standard install location etc. For some dumb reason I was playing around within MySQL Administrator, when I came upon the User Administration -> 'root' -> user privileges tab: Default values for max_connections_per_hour, max_questions, and were set to zero. "Zero isn't that many to play with; 100 might be better values for all these" I thought. So I changed them all to 100. Apply changes, no prob. exited out, came back to play later. (side note: didn't know at the time that zero is actually unlimited) Now for the problem: can't change any options. Can't connect sometimes. attempting to change the values back to zero in MySQL Administrator results in:
View Replies !
Resetting Root Password
I have set up mysql 5.0 (or whatever the latest version is), but for some reason it has lost what i set my root password is and i am tearing my hair out tryin to get back into the database. I have attempted the commands it tells you to do on the mysql official documentation and it jus comes back with an invalid command and I have also attempted to skip grant tables, which allows me to change the password but as soon as i start the service running again it jus goes back to way it was and doesn't let me in :(. And also reinstalled it like a billion times to discover it keeps the old root setup.
View Replies !
Resetting Username And Password
I recently downloaded WAMPServer 2.0. I have forgotten what my username is. My password is also just blank How do I reset my root username and password for MySQL? I have tried it on the command line (Windows XP) and it didn't work. I have no idea where such information would even be stored on my local WAMP server. I tried creating a php file, mysql_init.php, that would connect to my database, but when I open my browser and go to localhost/mysql_init.php. It says: Access denied for user ''@'localhost' to database 'sitename'
View Replies !
Resetting The Root Password On OS X
When I try to open MySQL, I get this error message: Access denied for user 'root'@'localhost' (using password: YES) According to the manual on this site, that means I have to re-set the root password. Is the procedure for doing this is OS X Terminal any different from the generic Unix one that the manual gives?
View Replies !
Truncate Table Not Resetting Autoindex
Im in the process of doing some testing on my site. Our host uses Mysql 4.0.25-standard. When I want to empty out a certain table that has an autoindex field, it doesnt rest the count ....what the heck ? im looking at the table in phpmyadmin, and there is the " Row Statistics: " stating this: Next Autoindex 23 even after doing a truncate table. droping and recreating the table of course solves the problem, but is this a bug ? I dont seem to have this problem with ver 5.0 on my workstation.
View Replies !
Resetting Root Password Doesn't Work...
I was attempting to change my root password using the following 3 means from the manual (I'd temporarily forgotten it), but was unable to. Would really appreciate it if someone could point me to why the following problems... (I recalled the password later, but would still be interested to know what's wrong below). If I use skip-grant-tables while starting up the server, I am not able to see any tables in the mysql database (though they are there and I can see them if I bring the server up normally and use the root password which I actually know). Code:
View Replies !
Windows 2003 To Windows XP Pro Secure Communications...
I have a Windows 2003 Server running a Coldfusion app that needs to constantly update a MySQL database on a Windows XP Pro machine. These machines are not on a LAN and are physically separate. I'm trying to find a way to establish secure communications between them since I do not want port 3306 open to the entire internet. What I've Tried So far I tried CopSSH with Putty but this did not work because I need to manually initiate all sessions and enter passwords by hand. Since there aren't any SSH solutions that allow persistent, automatic connections, it appears I need to go with VPN. The VPN Dilemma I tried creating a VPN server on the WinXP MySQL machine but I cannot get ODBC to work remotely. How do you get the ODBC on the local (Win 2003) machine to recognize the MySQL database on the remote (WinXP Pro) server? Note: I also understand that getting SSL working on Windows is a pain in the butt. I'm trying to steer completely clear of that. I don't have the tools to recompile, etc.
View Replies !
Permissions On Mac
I used MAMP to set up MySQL and Apache on my Mac and installed Drupal. Everything was working fine but I thought that I had forgotten to change the password for the 'root' user in mysql. So,with MAMP when you go to "localhost:8888 it gives you a start page where you can access mysqladmin and others. I used mysqladmin to change the root user properties but now when I try to launch the start page I get "could not connect with mysql server" Any idea how I can get to MySQL another way and fix it without having to reinstall? My Drupal installation still works so I know MySQL is working but I can't get to the admin/start page anymore. Also, I'm a complete newb at this stuff.. I know I can go to a terminal session on my Mac to access mysql directly but I don't know enough about it to do anything.
View Replies !
Default Permissions
This is a fairly simple question but I'm new to mySQL. To log on to mySQL I need to type at the prompt: mysql --user='username' --password='password' as opposed to just typing mysql and being recognized without having to type identification. Anyone know how I can change this?
View Replies !
Database Permissions
I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was wondering is there a way i can do a mysqldump on the databases on machine1, which will drop everything needed to recreate them in to a .sql file, transfer that to machine2 and then use mysqladmin to load it and have all the settings back in business? I believe they're both mysql4 installs, though machine1 might be mysql3.23, not sure.
View Replies !
MySQL Have No Permissions
I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting permissions correctly. Can anyone tell me which files and paths I should check (and change)? Ideally, I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
MySQL Permissions
I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
Permissions Change
Running MySQL 4.0.18 (upgraded from MySQL 3.x), I can set the host for a user to "%", and can connect from localhost just fine, as well as remote locations.On another server running 4.0.21 (clean install), if I set the host to "%", I cannot connect from localhost unless I also set a "localhost" entry as well for that user.
View Replies !
Permissions With New Db's
I've got php script that created a database, then the tables in the database. The user in which the script is run, doesn't have the permissions to create a 'new' db. Moreover, mysql says that because the user is trying to create a new db, and there isn't a row specifying that the use has permission, doesn't allow the user to create the db. My solution is that I can create a row in the mysql.db table that will allow for the user to have proper permissions. My problem is that once I insert that row, it takes another post to the page for the permission to actually take hold. Is there a way to have the permissions take hold sooner? Some of the things I have tried would be toRedirect the page to (with a php header call) to re-load the pageClose the mysql connection so that a new one would have to be opened
View Replies !
Resolving Permissions
I have mySQL Administrator (and subsequently mySQL) installed on my iBook. I want to connect to mySQL on my Red Had Linux 9 test server with the mySQL Administrator, but I get the following error message: Code: Could not connect to mySQL instance at [SERVER IP ADDRESS] Error: Host '[IBOOK IP ADDRESS]' is not allowed to connect to this mySQL server (code 1130) I'm sure there's an easy fix for this, but since I'm a bit new at this, I'm not sure where to look.
View Replies !
User Permissions
Is there a special permission required for a user to be able to run a "select ... into dumpfile" statement? I'm getting a 1045 error when attempting this on my server. I've already verified that file permissions are not an issue.
View Replies !
Custom Permissions
I need to assign different 3 different types of users, each with his own permissions and am unsure how to proceed. One of these users will require remote access to all records. I have mySQL 5 and mySQLadmin tool. Both are installed on WinXP and mySQL will be accessed through PHP's connection functions. Can someone show me an example of setting a user with specific table and row privileges for security purposes? ie: a a user can't modify adata in x table, only read. Another user can write in rows w and x of table y only and can read all of y table but not table z.
View Replies !
Trust Permissions
I am trying to configure a mySQL server on XP machine, and wish to allow ASP.NET application access the database from a remote machine. 1. How do I set Trust permissions to a catalog? 2. How do I allow remote connections?
View Replies !
Add Host To Permissions
Typically, one does something like "grant x,y,z on db.* to user1@localhost identified by 'password'". Is there a good way to clone the permissions for "user1@trusted-host1" et al? Particularly sometime later when one doesn't remember exactly what "x", "y" and "z" were exactly? I can look at the bazillion settings already there, but it's rather a pain to count exactly how many '"",''s and '"y",''s have to be where in the insert and what I really want is to just clone the entry, changing one field...
View Replies !
Outfile Permissions
I tried to write a query out to a file, but I got this message: ERROR 1 (HY000): Can't create/write to file '/home/jason/test.csv' (Errcode: 13) How can I set mysql to allow those permissions to write anywhere I want? When I don't specify the directory, the command works,
View Replies !
Root Permissions
root permissions are messed up, i'm unable to create new databases with root account and i cant change permissions for the root account while logged in as root mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Permissions Problem
I can query my MySQL database with any SELECT, UPDATE, DELETE, etc. queries, and it works perfectly, but when I try to do a LOAD DATA INFILE query, I get a permissions problem. Any ideas why this might be?
View Replies !
User Doesn't Have Permissions?
I install a mysql backup utility to backup my database if things go wrong. I went to test it to make sure it would work as it emails me the sql file, I deleted my database (using phpmyadmin) and tried to import the sql file which shoots me an error giving me an error that I didn't have permission to create a database. How do I give myself permission to create a database?
View Replies !
View User Permissions
Is there a way to query MySQL to find out what the permissions of the user currently connected For Example: Database: customer_contacts User : cust1 Table: Archives User Permissions: Read Only(SELECT). Is there a way to ask MySQL what User cust1 can do?
View Replies !
Database Creation Permissions
I have setup different MySQL users. I have removed all permissions for the users, and granted them full permission to their default databases I created for the. My question is, how can I grant the users permission to create databases. I want them to have full control to create databases, and delete any that they create. Is this possible, or do I need to create and remove databases for them as requested? I'm running mysql 3.2.5 on Redhat 9. I am not using any host permissions, table, or row permissions on the databases.
View Replies !
Remote Connection Permissions
I have mysql4 installed in RHEL4. I need to enable remote connection in this db so that application server can get connected to db server. For this, only creating user as grant all on db.* to remote@remoteipaddress identified by pwd; is this enough? or shud i do any other step.
View Replies !
Cannot Revoke Databases Permissions
I have Mysql 4.1.12 running on FreeBSD 4.9 in that i have 4 databases, mysql, test, new, and xyz I have one user abc, if i login through abc user i can see three databases new, test and xyz i want to remove access to xyz for user abc tried all command to remove access but didnt help and tried phpmyadmin also it seems when ever i create new abc user deleteing old it takes the old privileges of its own and again it shows access to 3 databases i just want access to test, new for user abc.
View Replies !
How To Check Permissions On Tables
I'm developing in Groupware (a php / template-based tool for making office-like applications). It creates mysql tables as it goes. I am not seeing those tables being created, and I'd like to determine if it's a permissions problem. I'm in a shell on a Linux system, but I'm very unfamiliar with Linux command line. So far, I can logon as root, use database, show tables; (this is how I know my tables aren't there.) So, what can I do to ensure that my permissions are set up correctly? When I was setting permissions in the Linux directories, I used 'chown'.
View Replies !
Creating A Database :: Don't Have Permissions
I put the commands in the terminal. mysql -h localhost -u metsuo -p Enter password: ******* then I get to where it shows "mysql>" then I type CREATE DATABASE shinko; and it says I don't have permisson as '@localhost' and I'm in root. Should I give write access to the directory?
View Replies !
Database User Permissions.
I have duplicated a working database which I wish to you. I have also duplicated the code (.asp) which reads, writes and updates the database. All works great when I am logged in to my PC because I have admin rights on this PC but when I test the exact same website with a general users account they get the following error:
View Replies !
Stored Procedures + Permissions
I'm on a shared host with MySQL 5.0.33. I want to use stored procedures and functions. Unfortunately I'm getting an error message when I try to create a new function. For example: SQL CREATE FUNCTION `gutenTag`() RETURNS varchar(20) CHARSET utf8 RETURN 'Guten Tag' ... ends with: #1044 - Access denied for user 'blah'@'%' to database 'blahblah' How can I check if I have permissions to create procedures/function?
View Replies !
Getting Current User Permissions
I'm on a shared host, but I'm looking for a "global" solution, since I'm writing an installer. I'm trying to get a list of the current user's permissions, I'm trying the user table, but no go. That's most likely blocked. I'm looking through commands, but nothing. Searching isn't turning up either. Is it just trial and error I guess, and catching the errors? What I want to do is to check if the user has the SELECT/INSERT/CREATE/DELETE/ALTER/UPDATE permissions, before proceeding.
View Replies !
Change/Create User Permissions
I have a remote db that I want to backup to my local MySQL server (windows). I can do a dump of the db from phpMyAdmin on the remote server. I try running it on my local server through the MySQL Control Center, and it says "Read Only". I don't have to enter password for root@localhost to login to the Control Center. I assume I don't have permissions to run DDL scripts as this user, and I can't figure out how to change this users permissions or create a new user with different privileges.
View Replies !
Newb Starting MySql-Permissions
I have debian running and this is how I have it setup # ls -ld /var/lib/mysql drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql I was shown how to setup a password for user mysql here http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt, because at one time all I would have to do it hit enter after # mysql -h localhost -p -u mysql Enter password: (no password is added I just hit enter) Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 16 to server version: 4.0.14-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> ( can do whatever I want now???) If I type in the correct password it lets me in, if I type in no passowrd it lets me in, if I type in the INCORRECT password it does NOT let me in. How can I make it so that if no password is typed it still treats it as incorrect?
View Replies !
Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).
View Replies !
|
TRACKER
