Authentication / Permission Basics
I have a number of users like 'fred', who can access MySQL 4.1 from %.fredworld.com. He has full access to his own database, fred. No other permissions defined.
What's the best way for me to allow every user to connect from localhost. After reading up on http://dev.mysql.com/doc/refman/4.1/en/connection-access.html I thought the answer might be to do:
insert into user (host, user) values ('localhost', '');
flush privileges;
but this doesn't do what I want. How should I go about this?
View Complete Forum Thread with Replies
Related Forum Messages:
Help Basics
i need some basic help to get me started with mysql my server is running ( mysqld as root gets it running) in the terminal window i have typed in commands like mysql create database my_data nothing seems to happen a blank line i try mysqladmin same thing what am i supposed to see after i type in commands like these? i have done some homework but still confused i am evaluating mysql as a database.
View Replies !
Basics
Give me the basics of what MySQL is, and how it works. Also I downloaded "Invision Boards" and I am trying to get it set up but I need an account with MySQL or something.
View Replies !
The Basics
I already started this topic in php, but this is the second part of it dealing with MySQL.I'm workin on a counter for my pages, I have already connected to the database and the database is created...now i need the code that opens a specific row, and changes the value, and then shows the value...please write the code
View Replies !
Basics Of Databases
I am having some diffeculty understanding db. am I right in thinking that tables hold the data which can be connected to other tables in th db by foreign keys . All of the data in the tables can be compiled into distinct sets of data and viewed by creating views of the data to be extracted from the tables. If so can views be used in a web page to display data, also what is the best way to input data into a db from a web site. I have read bits and pieces but can not find a good example from start to finish.
View Replies !
MySQL Basics
Give me a link to the mysql database download? I went to the site and I thought I installed what I needed, but I didn't understand and I don't think I downloaded the right thing. Next, Maybe some basic tips on how to set it up? Also, (this might be a post for the php subject) anyone familiar with installing the free phpbb system? I want to set it up using the MqSQL database. I have my own domain, and I can have it redirect to my web server, I just can't understand setting up mysql and the phpbb.
View Replies !
ORDER BY Basics
My table looks like the following communityname communitystatus = Either Future or Active area county city crossstreet1 crossstreet2 communitypk showroom = Boolean maps = Boolean logo = Boolean My query currently looks like this SELECT communitystatus, county, city, area, crossstreet1, crossstreet2, communityname, communitypk, showroom, maps, logo FROM community ORDER BY showroom, maps, logo, communitystatus, communityname LIMIT $limitvalue, $limit Of course the LIMIT is defined by a count query before hand for my pagination. For the most part (around 98%) showroom, maps, and logo are all NULL From my understanding of ORDER BY it will check the first column name and order the results by that column. Then all of the other column names specified work as tie breakers for the any criteria that matches. As you can probably tell from my query that isn't quite what I was hoping for. Is there a way for me to organize first by showroom, then by maps, then by logo, then by communitystatus, then by communityname? Basically what my I am attempting to do is if showroom = 1 then put those results on top, if maps = 1 then put those next, if logo = 1 then put those next, and then order all of the above by status then name. I'm not sure if a GROUP BY would help with this or not. I kind of have another workaround, where I add another column to the end of the table that is pointsystem, then I take and assign different values to different variables such as showroom = 3 maps = 2 logo = 1 Then I do an ORDER BY pointsystem, communitystatus, communityname.
View Replies !
Setting Up Database Basics
I'm a bit confused about the id unique key thing. I have a database with about 30 fields. Everything has been working fine. I just added a field called "id" and set it to Primary and Unique. Now, I can no longer submit information to the database. I get the error. "Duplicate entry '0' for key 1" 1. Do I need to send id a value and if so how does it automatically count for each record? 2. There must be a better way right?
View Replies !
DateTime Comparisons Basics
How do DateTime Comparisons work, if at all, and where is it documented. For example, '2006-03-13 15:23:00' - '2005-03-13 15:23:00' > '9:00:00' ? (i.e. '8760:00:00' > '9:00:00' ?) What are the proper function to use. I already tried TIMEDIFF and SUBTIME and none worked properly. UNIX_TIMESTAMP works very well in its timerange but is not what I need.
View Replies !
Relational Database Design Basics?
I'm just designing my first relational database, I've read ben Forta's MySQL Crashcourse book (but unfortunately it was a while ago), and just have a couple of questions. Is it ever a bad thing to have too many tables? For example, our suppliers have multiple telephone numbers and multiple email addresses. In the suppliers details table, instead of having columns named Tel1, Tel2, Tel3, and email1, email2, email3, I'm assuming I'm better off having separate tables, eg. SuppliersTel and SuppliersEmail, and within each of these have the Tel_ID (primary key), Suppliers_ID (foreign key) and Telephone. Is this the best way to design a relational database, or am I taking things too far? If I understand the principles behind relational databases then it seems this is the right way to do things - but it's looking like I'm going to end up with dozens of tables for my site - is this normal?
View Replies !
File Permission
I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2.
View Replies !
Users And Permission
Being that no user is accepted from the command line (even root) using the command: mysql -u root does anyone know if editing the 'users' database in /var/log/mysql with vi would help?
View Replies !
Connection / Permission
I have the following sitution... MySQL version 3.23.47 PHP version 4.3.2 Redhat Linux version 7.1 Apache version 1.3.29 I have a MySQL user called 'user' that is set up with full rights for localhost, 127.0.0.1, and the external IP address. I can connect to the database using all three users from the command line... ../mysql --user=user --password=password --host=###.###.##.### ../mysql --user=user --password=password --host=127.0.0.1 ../mysql --user=user --password=password --host=localhost But in my php script running on the server, I can only connect using the hostname localhost... $DBConnection = mysql_connect("localhost","user","password"); the IP addresses don't work... $DBConnection = mysql_connect("###.###.##.###","user","password"); $DBConnection = mysql_connect("127.0.0.1","user","password"); these give me the following error: Warning: mysql_connect(): Can't connect to MySQL server on 'domain.com' (111) Is there anyone that's seen this and can point me in the right direction?
View Replies !
My.cnf Permission Denied
When I try to access my.cnf file it gives me permission denied. Ay solution would be really nice, I need it for my site very fast. Yes, its my dedicated server I have acess to SSH, root and everything but I'm wondering why it gives me permission denied when i try acess my.cnf file.
View Replies !
INTO OUTFILE Permission
I have the MySQL server on a shared file server, and would like the internal network users to query the database and store the results in text or Excel format on their local drives (Or a mapped shared drive). Currently in the test version of this system,i have Mysql running on local host and the scripts on the same system. All the files are traded locally under test. But when i try to save the generated excel files to a shared location i get an error.
View Replies !
Permission Question
This thead springboards from a problem I had relating (to what I thought was) HTML. http://www.sitepoint.com/forums/showthread.php?t=406922 I have MySQL 4.1.15-standard with access via phpMyAdmin 2.6.0-pl3. Also running Apache 2.0. I have found lots of info on MySQL privilege/permission, and how to write the script, but what I can't find is where to put it. Do I put it in a .php file and "require" or "include" it on all applicable pages? An .htaccess or .htgroup? Are there any indept tutorials which explain this? If there are, I haven't found them. In short, I am looking for "you put a file 'permission.txt' in /var/www/local/folder". Right now, I have myself and a friend making blog entries. I did create a log in with sessions to allow access, but I did not go overboard on security. Would creating a table with privileges do the same, or fix my problem?
View Replies !
User Permission And ODBC
I am using SQLyog. I want to manage user permissions down to a field level which SQLyog does. Any DDL or DML statements that I attempt to execute within SQLyog support the defined user permissions. However, when I use MySQLCC the persmissions are totally ignored. This is also true when I attempt to access the database through ODBC using a number of third-party tools. My intent is to offer my clients the ability to access their data through ODBC with the option to restrict a specific set of users to sensitive data (Financials or salary amount column for Payroll) using a tool such as SQLyog. Is this possible that one tool has the permission and another not?
View Replies !
Connection/permission Problem
I have a MySQL user called 'user' that is set up with full rights for localhost, 127.0.0.1, and the external IP address. I can connect to the database using all three users from the command line... ../mysql --user=user --password=password --host=###.###.##.### ../mysql --user=user --password=password --host=127.0.0.1 ../mysql --user=user --password=password --host=localhost But in my php script running on the server, I can only connect using the hostname localhost... $DBConnection = mysql_connect("localhost","user","password"); the IP addresses don't work... $DBConnection = mysql_connect("###.###.##.###","user","password"); $DBConnection = mysql_connect("127.0.0.1","user","password"); these give me the following error: Warning: mysql_connect(): Can't connect to MySQL server on 'domain.com' (111) Is there anyone that's seen this and can point me in the right direction?
View Replies !
Permission On Dedicated Server
I just opened a new linux box as a dedicated server. I am trying to create a database for my client named client001. When I do this, I recieve the error message: "#1006 - Can't create database 'client001'. (errno: 13) After researching this I have found that this is generally the result of not having the permissions of my mysql Data Directory set properly. I rant "SHOW VARIABLES LIKE 'datadir'; in mysql and returned "/var/lib/mysql/" so I assume this is my Data Directory. I ran an ls -la on that directory and found that it has drwxr-xr-x permissions set.
View Replies !
MySQL User Permission
I have granted the following privilages GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; Now they can create databases, users and passwords. When I connect with navicat 2005 to hostname, root, password with 3306: I can see a database named 'information_schema' and thats not supposed to be there, because I dont want users to see it , because if they see it they can change important code and i dont want them to see it.
View Replies !
Permission Denied Without Asking Password
Have a problem thats driving me crazy! Using MySQL with PHP 4 on a Mac OSX. Installed MySQL and and tried to log on using various methods and get "Permission Denied" error. For example, logging in: ./mysql -h host -u user Get "Permission Denied" error instead of asking for password. I've tried all sorts of variations pickup up from manuals and other forums, but still get the same result. Also noticed that when I enter SHOW DATABASES, I only have the test database. The mysql database is missing.
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 !
Host Permission Denied
I have installed php and mysql on my machine at home and at work. I have done exactly the same for both but the one at home denies permission to my localhost where as the one at work works fine, connecting to my database from php and importing the info. At home both php and mysql work fine independently, I have set up username and passwords and granted total privileges to the user but I still cannot get it to connect. The only difference is I have a imac g5 at home where at work it is a power Mac, would this make a difference?
View Replies !
Mysqldump Permission Denied ! Why?
I have recently moved 103 websites 75 of those having MySQL databases. The last 2 sites that I am moving are giving me trouble when trying to dump the databases from Shell/SSH. At the command line I write: mysqldump -uUsername -p dbname > dbname.sql Then get the "Permission Denied" Message Whats going on? All of the details are correct! This server is running MySQL 4.1.20
View Replies !
Permission Architecture Design
I'm designing a large application and have a permission setting on certain objects. The application allows users to create their own private group of users. Users can have multiple groups of users in their list. Code:
View Replies !
Permission Denied When Try To Connect
I'm running the mysqld which came with Slackware 10.0 and am trying to connect to it via mysql-administrator but get an error message saying this host is not allowed to connect to the server. How would I go about fixing this? Is it in a config file somewhere, or a setting changed in the mysql server command line?
View Replies !
Permission Denied On Login
I've successfully installed mysql 4.0.26 on my powerbook os x 10.4.3 as the admin but I can't login as root using the terminal program to secure root accounts and create new accounts? shell> mysql -u root results in permission denied as do any other such commands from the manual.
View Replies !
You Don't Have Permission To Access /phpMyAdmin/ On This Server
when I go to http//localhost/phpMyAdmin/ using my browser, I get the following error. You don't have permission to access /phpMyAdmin/ on this server I have installed and configured php 5.0.2 and apache 1.3 and MySQL 4.1.7 and phpMyAdmin .6.0. Does anyone know what exact changes do I have to make to my httpd.conf file?
View Replies !
How To Set Create Table Permission In Myphp
I'm installing phorum on my site. I'm having a problem installing it, because it keeps saying: Could not create tables, database said: create command denied to user: 'irani_dk@localhost' for table 'dk_forums' Your database user will need to have create table permissions. If you know what the error is (tables already exist, etc.) and want to continue, click the button below. -- How do i set myphp to give permission? I'm logged in my myphp, but I just can't find anywhere where I can do it..
View Replies !
Permission Problem (Linux + MySSQL)
I installed MySQL and trying to get it working for few days, it wasn't easy. I am so massed up now it's not even funny, here is what I did. [root@localhost mysql]# mysqladmin -u root --password=<pass> it just gave me the mysqladmin help page [root@localhost mysql]# mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) [root@localhost mysql]# mysql -u mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 47 to server version: 4.0.17-standard Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> CREATE DATABASE HELLO_WORLD; ERROR 1044: Access denied for user: '@localhost' to database 'HELLO_WORLD' mysql> I use mysql with PHP, it was so easy, but when comes to command line, I don't know how it works.. From the above errors, can anyone tell me where I went wrong?
View Replies !
User Permission :: Select / Update / Insert /
I need to grant access to a user so that he can Select / Update / Insert / Delete, any information in one of the 200 database the server has, But in no circumstances must this user be able to access mysql database information nor modify it... I set up the user in mysql.user with The 4 permissions in this table, and there the user has access even to mysql... How can i assure that this user nevers sees mysql database...
View Replies !
Authentication
I'm new with mysql and I feel very stupid for having to ask this but I'm trying to program against it and I don't know what my username and pw are. When I installed it, I put in a pw so I'm pretty sure I know what that is, but what is the username I should be using when trying to execute sql commands against it with php?
View Replies !
Botched Mac Mysql Installation - Permission Related Issues
Code: jon-reids-power-mac-g4:~ jon$ mysqld_safe touch: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied chown: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 380: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied rm: /usr/local/mysql/data/jon-reids-power-mac-g4.local.pid: Permission denied /usr/local/mysql/bin/mysqld_safe: line 386: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied STOPPING server from pid file /usr/local/mysql/data/jon-reids-power-mac-g4.local.pid tee: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied 080616 21:52:09 mysqld ended tee: /usr/local/mysql/data/jon-reids-power-mac-g4.local.err: Permission denied jon-reids-power-mac-g4:~ jon$ sudo mysqld_safe Password: Starting mysqld daemon with databases from /usr/local/mysql/data
View Replies !
Authentication To MySQL
i have one problem with l'authentication to the MySQL; I am using the language Java and i access to the data-base in following db = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + nomeDB + "?user=" + nomeUtente + "&password=" + pwdUtente); but I do not want insert pwdUtente and nomeUtente in the source-code, What can i do?
View Replies !
Encryption / Authentication
I need to find out if it's possible to do two things with mysql. The = first is external authentication, preferably with kerberos5, but PAM = will work as well. Second, encrypting the data stream. Specifically = with jdbc connections.
View Replies !
MySQL And PHP Authentication
I'm getting the following error while trying to connect via php to an existant mysql (local) server: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client. I have latest PHP and MySQL installed. This seems like the password problem (new password system now) the older was 16 bits right? Thing is... My PHP should support this, its 5.x and I have latest mysql as well.
View Replies !
Support Authentication
i have installed php4.4 with iis and mysql5 and phpmyadmin is 2.5 version and mysql administration tool too i get the error client does not support authentication protocol, i will be very pleased if someone suggest a good workin version for all mysql php and phpmyadmin
View Replies !
User Authentication
I do know how to create user logins and such.what I need to know is once a user logs in and submits his data (CSV) to Mysql DB,how do i ensure that the data goes into his account.In other words,whats the best way to manage user accounts and control the data that goes into that.
View Replies !
Windows Authentication
I would like to a Windows Authentication with MySQL (similar to the Windows Authentication available for SQL Server). Does anyone knows how it can be done?
View Replies !
How To Log Authentication Failures ONLY?
I am trying to figure out how I can log _only_ authentication failures with mysql. It appears to me, that I can only either log all queries and mysqld errors, or only mysqld errors? I have tried in my.cnf: [mysqld] log = /var/log/mysql/access.log log_error = /var/log/mysql/error.log log_warnings = 1 But this logs every single query made, which I don't want, as it fills up the log files too much. If I do only [mysqld] log_error = /var/log/mysql/error.log log_warnings = 1 or... [mysqld] log_error = /var/log/mysql/error.log log_warnings = 2 ... then I get only mysqld errors, but nothing related to authentication failures. Is there a way to configure this?
View Replies !
Passwords / Authentication
I have just started messing around with MySQL and something I find weird is that we connecting using localhost, if I supply the password, it will not authenticate...if I leave the password off, it's fine.If I connect from another machine, it requires the password or it will not authenticate.Is that normal?
View Replies !
Slow Authentication
MySQL V 5.0.18 on SUSE 10.1 I'm not a complete *nix noob, but I sure as hell ain't a *nix or MySQL pro. This is a new installation. Everything screaming fast. Unless it deals w/authentication. Try to get in w/SQLyog from W2K locally ... intitial connection takes ~20 seconds. Then everything screaming fast. Web Server (W03) attempts to connect via MyODBC ... same result ... initial connection takes ~20 seconds. Subsequent queries screaming fast. VNC into the box at any time ... everything fast. (would seem to eliminate network/connection issues)
View Replies !
How To Change Read/write Permission On Mysql Data Base.
I had a total crash and the server guy gave me all my data in a hand basket.. just kidding.. Actually I was given the data all zipped up and the mysql data bases were separate and they were the direct downloads as follows: wp_comments.MYD wp_comments.MYI wp_comments.frm all data was in this format. I used SSH and uploaded it to the proper directory on the server and all is well at least as far as visitors seeing all the data.. but when I log into the site I get the following... WordPress database error: [Table 'wp_options' is read only] UPDATE wp_options SET option_value = 'O:9:"magpierss":18:{s:6:"parser";i:0;s:12:"current_item";a:0:{}s:5:"it ems";a:10:{i:0;a:12:{s:5:"title";s:13:"WordPress 2.2";s:4:"link";s:54:"http://wordpress.org/development/2007/05/wordpress-22/ I used SSH and tried to change the concerned files to writable and it works fine but the same error is generated. I can go direct to the data base using myAdmin and cannot edit (write) to any table. It says the data base is read only. On the same mysql area, I have another data base that was done via the normal way and I can write to it just fine. I can find nothing to change to make the site writeable. Any help here would be greatly appreciated.. SSH to the server and changing the files to writable has no effiect..
View Replies !
Can't Start Server : Bind On Unix Socket: Permission Denied
I have permission and owner ship for this folder set to user mysql and folder mysql-cluster is 777. Also, I am not running any other mysql server. Any help appreciated. Here is my error Quote: 070726 16:10:52 mysqld_safe Starting mysqld daemon with databases from /home/me/mysql/mysql-cluster /usr/local/mysql/libexec/mysqld: Table 'plugin' is read only 070726 16:10:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 070726 16:11:00 [Warning] NDB: server id set to zero will cause any other mysqld with bin log to log with wrong server id 070726 16:11:00 [Note] Starting MySQL Cluster Binlog Thread 070726 16:11:00 [ERROR] Can't start server : Bind on unix socket: Permission denied 070726 16:11:00 [ERROR] Do you already have another mysqld server running on socket: /home/me/mysql/mysql-cluster/mysql.sock ? 070726 16:11:00 [ERROR] Aborting 070726 16:11:01 [Note] Stopping Cluster Binlog 070726 16:11:01 [Note] Stopping Cluster Utility thread 070726 16:11:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete
View Replies !
Support Authentication Protocol
I have a service provider where my mySQL database is being held. Everything is uploaded and ready to go. When i try to access the database via my ASP code i get the following error message: Client does not support authentication protocol requested by server; consider upgrading MySQL client I've heard to use the Password/ Old password functions, but who has to do that, me or the service provider? When i try to use the Command prompt from the MySQL administrator it won't let me access the command prompt.
View Replies !
|
TRACKER
