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 Complete Forum Thread with Replies
Related Forum Messages:
MySQL Newb, VARCHAR Or TEXT?
Well, I'v been learning SQL because I'm trying to make a massive program for a site I'm working on and I wanted to create user login script. So I need to know which one I should use. Varchar or one of the text variation. I'v seen alot of scripts using varchar but when I was looking through my book all he used were the text variations. So I don't know what to do. Also, for the INT variations, how do they work? does the rand like 0-255 for tinyint does that just mean the integer in that section has to be between 0 and 255 or that that table will only be able to hold up to 255 differen't intergers?
View Replies !
Newb: Sorting And Summarizing Data
SQL Question: 1) I have to retrieve data from a database and sort the data by created_at DESC. 2) Using the retrieved data above, I also have to provide summary of sales records, that fall into each country, state and city. Would I be able to do 1 and 2 in a single SQL, without compromising the sorted data (by created_at DESC).
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 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 !
Creating Group Permissions In MySQL
I would like to be able to assign my employees to groups based on what department they are in (all users in accounting would belong to the accounting group, all users in customer service would belong to the customer service group). Then I want to be able to grant database permissions based on what group a user is in: something like GRANT SELECT TO myTable FOR AccountingGroup (obviously not ANSI SQL). Is there an easy way to do this?
View Replies !
User Permissions: MySQL DB Design
There is a huge problem I have been breaking my head over in the field of setting user permissions for my CMS. It is still in the development stage so I have all the freedom I need for any adjustments I need to make. My main focus of worry is on how to set the permissions, not in a static, but in a dynamic way. The end goal is to install the CMS for a variety of people. They will then have the control to make their own user groups and permission rules for each group and post. What I am having problems with is the following: Figuring out how to design the database to give me the options to: -Set read, write, edit, move, delete, vote, comment, attach permissions for posts. -Users can only do these things on posts of their user-level and lower or if they are the author. IF the post category allows this. Update: Where I am at now: I have decided to go with assigning 'levels' to each group and for each action. Level 0 is the admin level, the admin can do whatever he wants. Level 255 is a ban. I think I should set level-requirements on different types of posts. Let's say an admin announcement has edit-requirement level 0 where as an author article would have edit-requirement level 1 so only trusted mods can change it but reading-level 10 so all people can read it. (example level values). I was thinking something like this: posts[post_id....post_level_id=ì«'] post_permissions[permission_id=ì«', read_level=ཆ' edit_level=Ƈ' delete_level=Ɔ'....etc] Do you guys think this would be a good way to go? And how would you integrate this into the database? As stated before I edited the post a bit.
View Replies !
Unable To Connect To Mysql With Root Permissions
I am trying to connect to a new mysql installation. I have given root permission to connect to all databases from anywhere; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'passwd' WITH GRANT OPTION; I can log on locally by specifying the host name: [me@au101 me]$ mysql -h 127.0.0.1 -u root -p test Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 to server version: 5.0.18-standard However, when I try to log in locally without specifying the host name I receive the following error: [me@au101 me]$ mysql -u root -p mysql Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) If I try to connect remotely as root using MySQLyog I receive a similar error message: Access denied for user root@[my ip
View Replies !
Starting MYSQL...
--=_5D034890.F392DE43 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit This may be a very simple question and possibly could have a very simple solution to it. Since I have been using mysql for less than 2 months, I still consider myself a newbie.... I still cannot execute certain commands from my dos prompt, but I can run queries easily using phpmyadmin. I have purchased MYSQL Second Edition (Paul Dubois) so I hope to put it to good use soon.... The question that is of concern to me this morning is the prefered way to start mysql. I seem to think that I always have a problem because when I start my PC, mysql is already running as a service. But I am thinking that because I login to my PC as any user other than the dbase username, I have a problem afterwards. Must I always log on to my PC (Win2K) as the same user as the created user in my DBase in order for mysql to run properly?
View Replies !
Mysql Not Starting
I had to reload mysql 4.0.17 on to a Fedora Core machine that was previously working in the same configuration. Now though I can't get the server to run with the either of the following commands: ../mysql.server start - the command line reappears with no error but no running process in the system monitor /usr/local/mysql/bin/mysqld_safe -user=mysql - this command does not return to the command prompt so when I hit the enter key I get "Starting mysqld daemon with databases from /var/lib/mysql 0404124 00:13:21 mysqld ended. It looks to me as if it attempts to start but fails with no error. What am I missing on the reinstall?
View Replies !
Starting MYSQL On A Mac
I feel quite stupid I cannot seem to get MYSQL to even run on my Mac (OS X 10.4) I have installed MYSQL and then went to terminal and entered cd /usr/local/mysql then sudo ./bin/mysqld_safe then my password as prompted which is followed by Starting mysqld daemon with databases from /usr/local/mysql/data - at this point as it just seems to stop What next? I have tried entering mysql -u grifkerry -p but nothing happens! I have left it for a while but still nothing.
View Replies !
Starting Mysql 5.0.18
I type in the password and mysql closes. When I reinstall it as an anonymous user mysql asks me to type in my password. I've reinstalled the program a few times. I tried to reset the root password. None of these things work. I also saw that I have a file called prod.err. I open up the file and I see a bunch of stuff that I don't understand. I greatly appreciate anyone who could help me solve this problem. I've run out of ideas. prod6.err: InnoDB: The first specified data file .ibdata1 did not exist: InnoDB: a new database to be created! 060215 16:31:56 InnoDB: Setting file .ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060215 16:31:56 InnoDB: Log file .ib_logfile0 did not exist: new to be created InnoDB: Setting log file .ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 060215 16:31:57 InnoDB: Log file .ib_logfile1 did not exist: new to be created InnoDB: Setting log file .ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060215 16:31:57 InnoDB: Started; log sequence number 0 0 060215 16:31:58 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: ready for connections. Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 060215 16:52:38 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Normal shutdown 060215 16:52:39 InnoDB: Starting shutdown... 060215 16:52:40 InnoDB: Shutdown completed; log sequence number 0 43655 060215 16:52:40 [Note] C:Program FilesMySQLMySQL Server 5.0inmysqld-nt: Shutdown complete
View Replies !
MySQL Slow Starting Up
I am using a Windows 2003 Web Edition Server running IIS and MySQL 4.1. I had to restart the server the other day and it took MySQL almost 2 hours to come back up. I was watching it on my task manager and it went up to approximately 60,000k in 10k increments before I was able to access MySQL. My CPU usage was hovering around 3% all this time. Everything else came up on the server just fine. This happens every time I have to restart my server. The reason I have to restart my server most of the time, is because MySQL locks up on me. Is there any settings I can change that would help me here? Any help would be greatly appreciated. One more thing to add. I am using the default my.ini file. We have almost 100 different databases on the server and have around 20000 tables within all of these databases combined. All of these tables are InnoDB tables.
View Replies !
Starting Mysql With Mysqld
i'm trying to change the mysql data path. to do this, i have to shoot down mysql and restart it. i tryed to restart mysql with the program mysqld (i'm using windows xp, mysql server 5.0), but it doesn't work. why? is there any different way to start mysql? there was no error message or something like this. if i start it with mysqld --standalone, it works, but the command window doesn't replay anymore.
View Replies !
Starting With MySQL Administrator
I have just installed XAMPP on Ubuntu, and then i have installed MySQL Admin. After open MySQL Admin, i can see a window with "Server hostname", "Username" and "Password". I have written this: Server hostname: localhost Username: (blank) Password: (blank) I don't write any Username or Password because i can enter to MySQL server just with "mysql".
View Replies !
Mysql Server Is Not Starting
I have finished installing a copy of mysql from source on mandrake 10 (from source, not an rpm source) and everything went smoothly except starting mysql. I run "root@myBox> mysqld_safe --user=mysql &" and I get this message: Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/*my-ip-address*.pid 041219 12:06:03 mysqld ended so the server isn't starting, which is a problem. What have I done wrong?. These are the instructions I followed (with a slightly different ./configure line), which are from the mysql reference manual: 2.3.1 Source Installation Overview The basic commands you must execute to install a MySQL source distribution are:
View Replies !
Problem On Starting MySQL
Ubuntu-6.06-LAMP-server-amd64 I followed section "10 MySQL" on; http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4 and found "libmysqlclient12-dev" not installed. After installing it MySQL unabled to start. I reinstalled all packages recommended there. $ sudo apt-get install --reinstall mysql-server mysql-client libmysqlclient12-dev Password: Reading package lists... Done Building dependency tree... Done 0 upgraded, 0 newly installed, 3 reinstalled, 0 to remove and 8 not upgraded. Need to get 0B/3305kB of archives. After unpacking 0B of additional disk space will be used. Do you want to continue [Y/n]? (Reading database ... 82866 files and directories currently installed.) Preparing to replace libmysqlclient12-dev 4.0.24-10ubuntu2 (using .../libmysqlclient12-dev_4.0.24-10ubuntu2_amd64.deb) ... Unpacking replacement libmysqlclient12-dev ... Preparing to replace mysql-client 5.0.22-0ubuntu6.06.2 (using .../mysql-client_5.0.22-0ubuntu6.06.2_all.deb) ... Unpacking replacement mysql-client ... Preparing to replace mysql-server 5.0.22-0ubuntu6.06.2 (using .../mysql-server_5.0.22-0ubuntu6.06.2_all.deb) ... Unpacking replacement mysql-server ... Setting up libmysqlclient12-dev (4.0.24-10ubuntu2) ... Setting up mysql-client (5.0.22-0ubuntu6.06.2) ... Setting up mysql-server (5.0.22-0ubuntu6.06.2) ... $ sudo /etc/init.d/mysql restart Stopping MySQL database server: mysqld...failed. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' Killing MySQL database server by signal: mysqld. Starting MySQL database server: mysqld. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' Please advise which file I have to edit getting the problem fixed. TIA
View Replies !
Mysql Not Starting After VPS Server Reboot
I have a mysql db (Version: '4.0.22' FreeBSD port: mysql-server-4.0.22) running on an Verio VPS, and I am having an issue: After a power failure on Verio that meant restarted servers, etc, I saw that Mysql was not coming up. I checked the logs / etc and I got this message on /var/db/mysql/<hostname>.err: 060925 00:15:53 mysqld started 060925 0:15:53 bdb: Recovery function for LSN 1 29049 failed 060925 0:15:53 bdb: warning: ./testperl/testab.db: No such file or directory mysqld in free(): warning: chunk is already free 060925 0:15:53 Can't init databases 060925 0:15:53 Aborting There is no ./testperl/testab.db anywhere I can see, but OTOH, there should only be a few dbs and none of them is called testperl... Honestly, I have no idea of what might be hapening, but having the db is quite a PITA.
View Replies !
Starting MySQL 5.0.1 Server Up Problem...
I shutdown my MySQL server using MySQL Administrator 1.0. My problem is that i dont know how to start up the MySQL Server again. I tried to run mysqld-nt.exe by double clicking it but my server will not be up. If i restart my computer then thats the time my MySQL server will be up. Unlike MySQL 4.0.22 if i double click on winmysqladmin.exe my server will be up. Is there a way to put the server up without restarting my computer?
View Replies !
Problem Starting MySql From Root
I am in the process of creating a database which will serve as a backend for the registration of users' details and to handle account activation via the use of php scripts. I really need help with starting MySql. I have scoured various forums and followed instructions from the mysql.com, and other such tutorials. I am creating the website using dreamweaver on a windows 2000 pc but I am planning to place it on the linux box where the apache web server will handle it (if you know what I mean). The linux server is where the php and Mysql are installed. Incidentally the php installation is located in the /etc directory - and it works. I downloaded the Mysql binary file version 4.0.25 recently. Followed the installation instructions to the letter up to the change of ownership stuff. Code:
View Replies !
Prevent MySQL From Starting At Startup
I'm starting to play around with MySQL. How can I prevent it from starting up whenever my computer starts? It slows down the startup some, and I'm not always wanting to use it. besides, I can start it myself if I need it.I've had a look on Google for theis, and found quite a few results, but they were fo Linux or Unix. I'm ruinning Windows XP.
View Replies !
Starting Fresh With Mysql >> Dadabik
I have an Excel spreadsheet which has been my source document for the past several years for a collection I own. It has about 2000 entries (records) and each record has ~20 fields. Photographs of each item in the database are an integral part of this. What I'd like to do is move all of this knowledge onto the web in database fashion and provide a means to allow users to search the database. I found DaDaBIK which seems to be perfect for the show and tell phase of my project, but I need to create the database properly first. I can make a mysql database with my hosting account, but I don't know where to start. I know databases can be tricky; at least what I know of Access is tricky, so I want to do this right. I'm looking for help, maybe a simple tutorial, that will guide me through the process of transforming my Excel data and photos into a mysql database online. I have googled for this, but there are so many articles, and it is all over my head anyway.
View Replies !
Mysql Nt Service Stopped Starting After 2 Years
i have been running mysql on windows server 2003 for the last almost 2 years (its a really early version of mysql 4 anyway) but now all of a sudden mysql service stopped starting, i can go to services, press start and then refresh and its off again! i have a feeling that someone deleted the core mysql table (mysql) as it is now totally empty. im not too good with my sql as i generally use mssql or whatever, infact mysql never really installed properly, the only user i could ever use was root but i didnt mind this so i just left it and it was fine for 2 years but now its just stopped all of a sudden and i cant get it back on. i have enabled the mssql php exension as a backup system but i cant transfer any databases across without enabling mysql.. but it wont turn on! i tried several exes in e:mysqlin but none got it on (well one of them made the little winmysqladmin light go on for half a second)
View Replies !
Starting MySQL Database Server Mysqld [FAIL]
Right now, I am using Ubuntu 8.04 and using mysql 5.0.51a. I am receiving the following error: * Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.0; however: Package mysql-server-5.0 is not configured yet. dpkg: error processing mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.0 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)
View Replies !
Mysql 5.1 Windows Realease Server Starting Problem
I am a new user to MySQL, and I have run into difficulties starting it. I have successfully done this once a while back, and than had to go away for a while. I am now trying to start the server again via the windows command line. I type: "C:Program FilesMySQLMySQL Server 5.1inmysqld" as directed from section 2.3.10 of the user guide and nothing happens. It just returns C prompt. I then use "C:Program FilesMySQLMySQL Server 5.1inmysqld" --console; this gives screen output as I do not get a data directory with an error file without '--console' The output is: 090419 17:30:38 InnoDB: Operating system error number 5 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. It may also be you have reated a subdiretory InnoDB: of the same name as a data file. InnoDB: File name .ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. And then goes back to C prompt on the command line. Can anyone help me? If memory serves, I followed the user guide to the letter when I started (save for the post-startup material). As well (and possibly related), I have the mysql command line client in windows on the desktop (c:program filesmysqlmysql server 5.1inmysql.exe). I click this and it prompts me for 'enter password'. I don't ever remember entering a password the last time which may be related to the first problem staring mysql server from the command line.
View Replies !
Starting MySQL Server With Federated Engine Support
I have MySQL service installed on my machine. I want to start the MySQL server with FEDERATED engine support. According to MySQL Federated Engine, I should start the server with --federated option. Where do I need to change this? I tried adding federated to the my.cnf file. Then Federated engine started working and InnoDB stopped working. After adding this line, I executed MySQL Code: SHOW ENGINES; There, I couldn't find InnoDB in list.
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 !
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 !
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 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 !
|
TRACKER
