Configure 2 Sites To Access One User Table
I have two databases on the same server with different domains. I would like both sites to access the same user database table. They have the same fields.
I thought that it might just be done with an mysql command, which will point one table to the other.
View Complete Forum Thread with Replies
Related Forum Messages:
Two Sites Using The Same Forum Database User List
I know it's possible for TWO different sites to use the same database. Let me explain. I have siteA and it runs a forum. Through the site, users of the forum can login using their forum ID. I now create siteB on a different domain, but on the same hosting service. I want users from siteA to be able to login with their name from that site on siteB. How would I do this? I'm using myBB as my forum software.
View Replies !
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
View Replies !
Access Denied For User: 'user@172.22.0.1' (Using Password: YES)
I am currently running two servers one with Tomcat and the other with MySQL. They are both in different Windows domains and on different network segments. I have the following users on the MySQL server: user@localhost user@% I am getting a VERRRY SLOOOW connection between the two machines so I thought I'd add a user just for the Tomcat server. The IP address of the Tomcat server is 172.22.0.1 so naturally the user would be 'user@172.22.0.1' When I added this user I got the following error Access denied for user: 'user@172.22.0.1' (Using password: YES) Any ideas on what I can do to remedy the situation?
View Replies !
User Access
I have added a user, this user can attach to mysql i.e. mysql -Uusername -P database, but they can't access the database I want via use database; What permissions do I need to check?
View Replies !
Large Commercial Sites
For the past few months I have been learning PHP and MySQL in my free time. I have ideas for money making entrepreneur-style websites (worth a try, right? ). I'd like to develop the sites myself but I'm struggling to find resources that offer a straight up, detailed guide to creating high traffic database driven websites. So far all the books I have bought come across as "here's a chapter on how to make x application, but in the real world it's much more complex". In other words, workaround solutions that wouldn't be suitable for ACTUAL high traffic db driven sites. I'm understanding the material fine, it just doesn't seem thorough enough for real world. I'm contemplating buying Sitepoint's "Build Your Own Database Driven Website Using PHP & MySQL", but since each book I've bought costed $20-40 and so far none of them have been up to what I'd consider industry standard, I'm slightly reluctant to shell out another $40 at risk of getting rehashed version of the "watered down version of real world apps" style approach the other books had. Has anyone bought this book? Would you be able to develop a site like, say, IGN using the info in it? Alternatively, if anybody can list a few key points that I can research (i.e. security issues, relational databases etc.) I'd be more than happy to go off and locate the articles myself. It's just knowing what I need to LEARN that's the problem.
View Replies !
Access Denied For User
I created a new user with the grant command and yet, I can't login into the database I must mention that the user was created but all the privileges are set to 'N'. This is what i get trying to login with the new user I created. "ERROR 1045 (28000): Access denied for user 'nsac'@'localhost' (using password: YES)"
View Replies !
Setting Up User Access
I am trying to set up a little webhosting thing for my friends. I do have a pretty decent knowlage with linux but not mysql. How can you make users and limit them to edit ONLY one database? I cant quite figure this out. I have done a lot of research, maybe im just not looking in the right place.
View Replies !
Random User Access
I installed mysql a few days ago and it seems that I misconfigured the users permissions. I created a root user with a password, and it works just fine, I can log in mysql with any random user name that I enter and a blank password, and that is a real problem. How can I deny access to all unknown user names?
View Replies !
Restricting User Access
Is there any way that I can restrict users' access to rows of a given table based on the value of a particular field? I can imagine how to do it when selecting records but I would like to it "more generally".
View Replies !
Access Denied For User:
I have just installed a copy of MySql, Appache and PHP All works well except that I get this error message in the MySQL error log [client 127.0.0.1] PHP Warning:
View Replies !
Error 1142 - Mes. The Following Occured: SELECT Command Denied To User Xx@hostx.com For Table 'user
When trying to do anything to do with "User Administration" in MySQL Administrator 5.1 connecting to a remote MySQL database, I get the following message when I click on the "User Administration" icon/text in top left frame. Verbatim quote apart from my connection details which I am anonymising): A MySQL error was encountered. The message is: Could not fetch user names. The following occured: SELECT command denied to user xxx@hostxxx.xxx.xxx.com for table 'user' (1142) No I have looked through search and found the following: http://lists.mysql.com/mysql/134369 Unfortunately that tells me that it has happened to someone else but that's about it. What is one supposed to do with the fix? I am wondering if this is why I cannot create ordrop any tables with this username at the moment, even though it is the Admin level username....
View Replies !
Database Synchronisation On Two Remote Sites
I am considering the possibility of trying to keep a user table synchronised on two different sites. This is not something i've done before so i'm looking for any tips that might help me on my way. Basically I was thinking of: - scheduling php script to connect to both databases via cron to update the table at regular intervals - generating an xml feed and doing the same thing Both methods would potentially involve storing a pointer to only read and write the new rows, although perhaps I could use DATETIME to also copy accounts that have been updated since last run. Probably biggest concern is: - security... operating in a way that the data is private. The most sensitive data is hashed passwords and postal addresses, I don't think it would be appropriate to not somehow protect this info during transfers. I'm not sure whether SSL is an option (should be) but possibly I was thinking of creating some kind of token system. - bandwidth. both sites should be fine resource wise but due to my lack of experience in these matters I don't really know what the performance hit will be, and I would like to run the script very often As far as I know alot of big sites (for example hotel booking engines) use xml in the background to share info but I really have no idea how it all works.
View Replies !
Sharing Data Across Multiple Sites
Sorry if this has been addressed on this board, but I am getting some serious Hour glass action, when I attempt to search this board. I am attempting to put multiple sites together that utilize one common database with common tables. I wanted to get some advise on how the table can be implemented efficiently. The concept is I have multiple sites that share the same code and database. I will assign a site ID to distinguish between the sites. Some Article data will be shared across the sites. Example: I have a site for Bass Guitar, Lead Guitar, Keyboard, Saxophone, etc. A component of the site will be articles written about music theory, that can span all these sites. How can I implement a solution that allows One article to be placed on all these sites based on the site ID. I was thinking of one of two ways (and ofcourse there might be an even easier way, i haven't thought about) Option 1 Having a field in the database named after each site or siteID, and in my query having a WHERE Clause in the code based on the siteID ie: "WHERE Bass = 1" for the bass site, and on the Saxophone site the same code would be there "WHERE Sax = 1" that way on each site If the article has a 1 in the field, it would display. I don't think it is efficient and if I where to use this concept across a large number of sites, it would very quickly become a nightmare to maintain. Option 2 Having a field that receives a comma delimited data, that can be parsed with SQL and displaying the results if the data is present. With option two I do not know how to do it with SQL any insight? Is this efficient?
View Replies !
Hosted Mysql User Access
I have mysql, php and apache all hosted and am trying to use phpmyadmin to connect to the database however I get a user access problem, it says access denied.
View Replies !
PHPmyAdmin :: Access Denied For User
I login to my cPanel and click PhpMyAdmin and try to create the table "x_referrers" and it spits on the error message: #1044 - Access denied for user: 'x@localhost' to database 'x_referrers' It's never done this before, nor have I changed anything, what should I do?
View Replies !
Mysql_pconnect() :: Access Denied For User
Warning: mysql_pconnect(): Access denied for user: 'rosschilen@localhost' (Using password: YES) in /usr/share/webcalendar/includes/php-dbi.php on line 57 Error connecting to database: Access denied for user: 'rosschilen@localhost' (Using password: YES) i have the user 'rosschilen' setup in the /etc/webcalendar/settings.php file. I tried to setup the user 'rosschilen' in the database as it states in the admin documentation but i dont think i did it properly. I dont understand the notation(options) in the following command: mysql> GRANT ALL PRIVILEGES ON *.* TO webcalendar@localhost
View Replies !
Mysql User With Shell Access
Is there any reason the mysql user account in a linux system would need shell access and a password? I thought it was just there to be a very underprivileged user and run the mysqld daemon.
View Replies !
Error: 'Access Denied For User
I have recently upgraded to mysql-4.0.23 from mysql-3.23 on linux system. I started the server using the command: /usr/bin/mysqld_safe --user=root & When I try to shutdown the server using the command: mysqladmin --user=root shutdown I am getting the error as follows : /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' And hence to shudown the server,i always need to kill the running mysqld process.I dont think its advisable to do this always. Please ,help me in this regard and tell me the right command to shutdown the server.
View Replies !
Access Denied For User - #1044
I'm trying to migrate an SQL file to a new server and getting the following error message when trying to upload: "MySQL said: #1044 - Access denied for user 'XXXX'@'localhost' to database 'YYYY'" What am I doing wrong?
View Replies !
Mysqldump :: Access Denied For User
I am new to MySQL Database. anyhow i managed to design and communicate with database in my project (along with some stored procedures) on my local system. But now i want to export this database along with stored procedures to a remote host. Following are the commands i used. ------------------------------------------------------------------------------ mysqladmin -h 'hostIP' -u root -proot create my_db_name mysqldump -u root -proot -R | mysql -h 'hostIP' -u root -proot my_db_name ------------------------------------------------------------------------------ the result is that database is created on the remote server and tables also exported but stored procedures are not exported to remote host. i am getting following error message "access denied for user 'root'@'%' for database my_db_name got errno 22 on write" i added privileges for creating and altering routines for user with host "%" in user table of mysql database on remote host.BUT still i am getting the same result as above. Can anybody please resolve this issue.....
View Replies !
1045 Access Denied For User
I made a db through Cpanel as usual (usr.pw-all privileges). If I go now to phpmyadmin I see the db but don't see the users. I only see "No privileges" in red, although I made a user to the db in a correct manner. when I want to make contact with the db through dreamweaver he gives the error: 1045 denied for user to access.
View Replies !
ODBC :: Access Denied For User ...
I want to connect to my mysql database using ODBC Connector 3.51 but it isn't works. When I click on 'Test', the system show me "Access denied for user macxxxx@200.121.10.43". This IP belong to my ADSL Internet Provider (Speedy, Telefonica). I have try with 'localhost', 'mydomain.com' and with my server IP but nothing. What happen? Do I need configurate something in Connect Option or Advanced?
View Replies !
Connecting To Yahoo Webhosting MySQL Sites
1. I've signed up for yahoo webhosting because they had MySQL 2. Installed their phpadmin tools and setup the admin username / password for my db's, create one db and table 3. I downloaded and installd the MySQL GUI tools 4. Pointed MySQL admin to my domain name with un/pw default port 3306 And all I get is "Can't connect to MySQL server on domain name (10060)
View Replies !
Normalizing The Unknown - Multiple Sites Setup
This question is about whether to share common tables across multiple sites that share the same database. Mainly, the 'Members' registration table along with others for run times, ad descriptions, payment processing etc. Of course sharing the tables could simplify things (creating same queries across multiple sites, for example) BUT looking ahead toward the sites which are wholly undeveloped with fields not really known ..I am starting with one large US city site. Other sites will be one for Paris, France - not entirely sure of how common the fields might be at this point since I'm not certain how they do things in the French quarters! And a site for pilot training. However all members/registrations will be signing up for a single purpose - they are placing paid-for advertising on the sites. So generally they are similiar -- at least for signup, though added tables may vary. Also, there is consumer oriented advertising and business geared ads. (different runtimes/pricing but I don't think this matters) The sites may be split apart at some future point. So in this interest, to move the tables back apart -- I think it easier to keep any 'Members'/registration tables seperate, even though rowid's might be preserved in the moving. The big advantage I see for sharing at least a Members table is keeping the rowid discreet and avoiding confusion. While it may create gaps in rows or structurally bind things if the sites on the database end up being split off into their own seperate databases. What might be the deciding factors at this stage, murky as it is?
View Replies !
Error 1045: Access Denied For User
why each time I try to access my database using: c:mysqlininmysql -root -p and afterwards:(i.e. after inputting my at the password prompt) Enter Password: '******' I get the following: Error 1045: Access denied for user: 'ODBC@localhost'(Using password: YES) This is rather confusing to me, as I'm pretty sure that I had used the same password to pass through this particular 'door' yesterday my settings are in the following format: mysql>SET PASSWORD FOR root@localhost=PASSWORD("******"); Query OK, 0 rows affected (0.00 sec) mysql>SET PASSWORD FOR root@"%"=PASSWORD("******"); Query OK, 0 rows affected (0.00 sec) mysql>FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Really the password that I'm using is exactly the same one I had assigned to my root few days ago after installing MySQL, PHP and APACHE successfuly, and which I have been using without problem until this afternoon.
View Replies !
Access Denied For User ''@'localhost' To Database
Yesterday I got a new server with MySQL 5.0.22. Today I spent 10 hours trying to set up a database using webmin. Actually, it's not a problem to create a database, but the problem is that I can not connect. I tried different settings, no luck: Access denied for user ''@'localhost' to database 'mydatabase' I can connect from command line: [root@server8]# mysql -u myusername -p Enter password: *** Welcome to the MySQL monitor. Commands end with ; or g. ....... As you see I can connect. My settings from webmin: Code:
View Replies !
Adding New User Accounts :: Access Denied
I have read Ref Manual 5.9.2 Adding New User Accounts and 5.8.8 Causes of Access Denied. I am running SUSE 10.1: /usr/sbin/mysqld Ver 5.0.18 for suse-linux on i686 (SUSE MySQL RPM) This works: mysql -u root -ppassword mysql Using user root, from Python I can access sql, add data to tables, etc. but I want to set up other users and access mysql from other than localhost. I tried this (as suggested in 5.9.2): mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'localhost' -> IDENTIFIED BY 'password' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'pwh'@'%' -> IDENTIFIED BY 'password' WITH GRANT OPTION; But this happens: mysql -u pwh -ppassword ERROR 1045 (28000): Access denied for user 'pwh'@'localhost' (using password: YES) Ref man 5.8.8 says if all else fails, reinstall from the source. I started to do that but got stuck. I would rather not if it can be avoided.
View Replies !
Access Denied For User 'ODBC'@'localhost'
I tried out all instructions that given in to several forum releated to this topic but error remain as it is. Some times mysqld-nt start sometimes not... if it start it gives Access denied error odbc@localhost(unsing password "No") I'd also tried out information that given in several forums.. but problem remains exist. OS- windows vista.
View Replies !
SugarCRM Application :: Access Denied For User
I am using MySQL as the database for my SugarCRM application. I have been playing with the users and hosts so that I can connect to the MySQL database from other workstations. In the process, I seemed to have messed up the 'root' user. Now I am unable to connect to the database. I get the Access denied for user 'root'@'localhost' (using password: YES) error when I try to open the MySQL administrator or try any type of connection. How can I re-enable the 'root' user without having to re-install?
View Replies !
#1044 - Access Denied For User: '@localhost'
I've installed mysql on my macintosh OSX. Everything was fine before I tried to enter a password for the root user (using the terminal window). After that I could'nt acces to my phpmyadmin or local web site adress. I used a free software "navicat" to go and see the "manager user" section and made a big mistake touching privileges !!!!! I don't have anymore PRIVILEGES on nothing .... I can't access to anything anymore :(((((((( Does someone have the lines codes so I can restore ALL PRIVILEGE for the root and locahost ?? her is the kind of message I get on phpmyadmin : #1044 - Access denied for user: '@localhost'
View Replies !
Access Denied For User 'ODBC' @ 'localhost'.. : )
i'm using windows 2000, PHP 4.3, APACHE 2.0 web server and MYSQL 4.1 i've installed MYSQL correctly, but when i tried to type this command --> c:mysqlshow then error message come out--> access denied for user 'ODBC'@'localhost' <'using password: NO'> so i tried to fix it, and re-enter this command with password --> c:mysqlshow -p but again error message come out --> access denied for user 'ODBC'@'localhost' <'using password: YES'>
View Replies !
Access Denied For User Odbc@localhost
I am trying to install mysql on my localhost, i have had someone in and also tried on my own but cannot seem to get into it. As far as i am aware the error is due to a wrong password. The error i get in command line: Access denied for user 'DBC@localhost' (using password : NO) The error i get when trying to run in explorer (i have done all the obvious things i expect so i just got http://localhost/....): Unknown MySQL Server Host 'mysql' (11001) in C:Documents.....
View Replies !
Access Denied For User 'root@localhost'
I have installed MySQL and somehow have my forum running fine using it, however, I am attempting to install Photopost php software and I have put in the user name that I have been using. It all works fine up until it tries to create tables on the database (and maybe even a database, the error message isn't telling me much). I have tried to log into mySQL but keep getting the error: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) The error I get from the install page (of Photopost) is: Could not connect to or create the PhotoPost Classifieds database. Be sure your user has permissions to CREATE or create a blank table before hitting REFRESH or go back to Step 1 to check your database settings. Presumably I need to go in to mySQL as root and set CREATE etc... permissions for the user that I have specified in the Photopost install script? How can I do this? I have never set up a root password for mySQL. I am completely new to MySQL (although I have used it for my own developments on Windows, but never on Linux).
View Replies !
PhpMyAdmin - #1044 - Access Denied For User
I am attempting to setup my database with my host, Turtle Hosting. I'm using phpMyAdmin, but it is giving me the error: SQL query: CREATE DATABASE IF NOT EXISTS `crmpicco_mini` ; MySQL said: Documentation #1044 - Access denied for user 'ayrshire'@'localhost' to database 'crmpicco_mini' I logged into my MySQL Client on my local machine, and entered: "GRANT ALL PRIVILEGES on crmpicco_mini.* TO 'ayrshire' IDENTIFIED BY 'mypassword';" I log into my control panel with Turtle Hosting with the username 'ayrshire', so i presume that is why it has defaulted to 'ayrshire' as the db username.
View Replies !
Warning: Mysql_connect(): Access Denied For User:
any ideas hoe to fix this: Warning: mysql_connect(): Access denied for user: 'admin@localhost' (Using password: YES) in /home/admin/public_html/_database.php on line 55 ............................. I looked on the server and it appears that all the users are gone? Thanks
View Replies !
Access Denied For User 'root'@'localhost'
I am having this error message: Check the pictures #1045 - Access denied for user 'root'@'localhost' (using password: YES) I am using WAMP5,I tried to change the password in config file but no use.last time I had to uninstall and reinstall to reset the root password. what am I doing wrong?am I looking at the wrong file?
View Replies !
Error: 'Access Denied For User 'root'@'localhost'
I've used mysql on an XP machine before, but only a little. I installed Fedora core 5 on this machine (i386) and have mysql 5.0 running. I understand that this is a common problem and I have been searching for a solution for a few days now. When I was configuring Fedora using this guide (FYI: I only installed what I needed), I used this command to set the root password (assuming that I was using 'root' as my password): mysqladmin -u root password root Then, I tried this command to login (as instructed by the guide I was following): mysqladmin -h localhost -u root password root This is where I got the error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Now, I have tried many methods to fix this. I tried every method to reset the root password as instructed by the mysql documentation. I also installed Fedora core 5 on another hard drive at home to see if I would still get the same error and I did. I know that localhost is the correct host name and the mysql service was running while I was trying to login. I've read a lot of post here already and nothing has helped me.
View Replies !
ERROR 1044 (42000): Access Denied For User 'x'
I've just started learning MySQL and have found lots of useful information on the Net. I'm working on my own and am stuck here (at the very beginning!): mysql> create database menagerie; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'menagerie' mysql> I'm using the following tutorial: http://dev.mysql.com/doc/refman/5.0/en/creating-database.html I'm using Fedora Core 6, I've done the "service mysqld start" thing, then opened mysql. No password or username was asked of me. Here are some more elements: version ("select version();"): 5.0.27 username ("select user();"): linux@localhost (my OS username is 'linux') I've found lots of information on the subject, but haven't been able to find a simple explanation to get around this problem (host, username, password). Also, I can't figure out where MySQL information is stored on Fedora Core 6. Does anybody know?
View Replies !
Access Denied For User 'root'@'localhost' (using Password: YES)
I am trying to login to mysql using 'mysql -u root -p' with password.but iam getting this error "Access denied for user 'root'@'localhost' (using password: YES)". i have googled for this error and i saw that if i enter a wrong password i get this error.but i am 100% sure that the password is right because i used it in a sample program where i gave that password to connect to mysql.
View Replies !
Access Denied For User 'ODBC'@'localhost' (using Password: NO)
I am having a problem connecting to mysql from php. Here is my code: <html><body> <? mysql_pconnect("localhost", "root", "password"); mysql_select_db("lead"); $query = "select * from products"; $res = mysql_query($query); if($res === false){ print "Error: $query<br>" . mysql_error() . "<br> "; exit(0); } while($row = mysql_fetcharray($res)){ print "$row[0]<br> "; } ?> </body></html> I've read somewhere that this is a known issue and that you could down grade to fix it, but I couldn't find anymore information than that. What needs to be downgraded, and to what version? Mysql 4.1.5, Apache2, Win 2000, php 5.0.1.
View Replies !
|
TRACKER
