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 Complete Forum Thread with Replies
Related Forum Messages:
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 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 !
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 !
One Database For Site And Forum?
I have a site and a forum and I want to use one database for them, so when somebody registers in the site - to be registered automatically in the forum. Is this possible and if it is - how?
View Replies !
Moving Forum That Uses Database
AOn my website that I am busy rebuilding, I have a forum that uses the MySQL database. The current path of the forum is this: ingwaz.nl/main/ingwaz.nl/berichtenbord/mercuryboard/index.php Which is obviously way too long, blame it to inexperience when it comes to designing websites :rolleyes: I want the path to become this: ingwaz.nl/main/berichtenbord/index.php The question is, can I move the forum from one folder to another without problems or is this going to mess up the linking with the tables in the database?
View Replies !
Combining A Chat & Forum Database
But how would I combine a chat and forum so that if one registered for one of them then they would register for both? Basically how would I make a database allowing someone access to any part of the site?
View Replies !
Forum Database Merging Question
I am very new to databases although I have backed up, and imported several forum db's using BigDump. That's as far as my knowledge goes i'm afraid. I have two similar smf forum dumps which I would like to merge into one database. If you imagine and old forum added to a new forum, or two different forums that decide to merge all their boards, posts and members into one. I have spent some time now reading up on sql, searching for scripts and creating databases in an attempt to get this to work. As I have said, I am a real novice at this kind of thing and would really appreciate some help. Basically a script would be a dream come true, but I have yet to find one. I am prepaired to read, learn and experiment if somebody could just point me in the right direction. Lastly, if this has been achieved before, a link to a guide or howto would be amazing.
View Replies !
User List
I'm trying to show all the databases that exist, as well as the users that belong to each of them. Do you have any idea of how can it be the query to obtain this.
View Replies !
User View List Of Databases
I have a Mysql 4.0.18 database running on windows. From another windows server (10.1.1.4), PhpMyAdmin connects to the mysql database using admin1 as login and the corresponding password. However, this user can list all the databases that are hosted on the mysql server. Below are some queries that I have run with respect to admin1. The most interesting part is the output of the statement: show grants for 'admin1'@'10.1.1.4'; 1. the only grant statement I type for this user is: GRANT SELECT, INSERT, UPDATE, DELETE ON `admindb`.* TO 'admin1'@'10.1.1.4' How did the additional line get added: GRANT SHOW DATABASES, CREATE mysqlORARY TABLES, LOCK TABLES ON *.* TO 'admin1' @'10.1.1.4' IDENTIFIED BY PASSWORD '56b208421693456' |? 2. If I type: REVOKE ALL PRIVILEGES ON *.* FROM 'admin1'@'10.1.1.4'; admin1 is no more able to list the databases. But now another statement appears when I list the grants: | GRANT USAGE ON *.* TO 'admin1'@'10.1.1.4' IDENTIFIED BY PASSWORD '56b2084216979f06' | What does this statement mean and how did it get there ? 3. But if I restart the mysql service after revoking all privileges, admin1 can see the list once again. What must I change to let user admin1 list and manipulate his database (admindb) only ? 4. Running mysql> SOURCE c:mysqlscriptsmysql_fix_privilege_tables.sql Below are the privileges of admindb and the my.ini file. I have also installed Mysql 5.0 on a separate machine. But the same problem occurs.
View Replies !
User Sees List Of All Databases
this question has been posted before but I have not yet found an answer suitable for my case. I am not very knowledgeable concerning mysql so please excuse the simplicity of my questions. I have a Mysql 4.0.18 database running on windows. From another windows server (10.1.1.4), PhpMyAdmin connects to the mysql database using admin1 as login and the corresponding password. However, this user can list all the databases that are hosted on the mysql server. Below are some queries that I have run with respect to admin1. The most interesting part is the output of the statement: show grants for 'admin1'@'10.1.1.4'; 1. the only grant statement I type for this user is: GRANT SELECT, INSERT, UPDATE, DELETE ON `admindb`.* TO 'admin1'@'10.1.1.4' How did the additional line get added: GRANT SHOW DATABASES, CREATE mysqlORARY TABLES, LOCK TABLES ON *.* TO 'admin1' @'10.1.1.4' IDENTIFIED BY PASSWORD '56b208421693456' |? 2. If I type: REVOKE ALL PRIVILEGES ON *.* FROM 'admin1'@'10.1.1.4'; admin1 is no more able to list the databases. But now another statement appears when I list the grants: | GRANT USAGE ON *.* TO 'admin1'@'10.1.1.4' IDENTIFIED BY PASSWORD '56b2084216979f06' | What does this statement mean and how did it get there ? 3. But if I restart the mysql service after revoking all privileges, admin1 can see the list once again. What must I change to let user admin1 list and manipulate his database (admindb) only ?
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 !
Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do mysqladmin -u root password 'password' but it says "Access denied for user root@localhost"
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 !
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 !
Database List Structure
Here is my situation: I have a table of `clients` (id, name, etc..) I have a table of `items` (id, name, etc.. ) each `client` can have 0-Many `items` assigned to them. How would I go about setting up the relation of this? should I create a new table with `item` id's and `client` id's, then query the DB for all `items` with a `client` id?
View Replies !
Getting List Of Tables In Database
i am using the following command in my php page. " show tables from test; " it will show me the number of tables in the database but which column name i refer to call the names of the table.... can any one help me in this regard, here is my code that i use... <? $query_showtable = "SHOW TABLES from test;"; $row_showtable = mysql_fetch_assoc($showtable); $totalRows_showtable = mysql_num_rows($showtable); print '<br>' .$totalRows_showtable; ?> <table border="1" cellpadding="3" cellspacing="2" bordercolor="#000000" class="style1"> <tr> <th class="style1">List of Tables</th> </tr> <?php do { ?> <tr> <td class="style1"><?php echo $row_showtable["tables"]; ?></td> </tr> <?php } while ($row_showtable = mysql_fetch_assoc($showtable)); ?> </table> <? mysql_free_result($showtable); ?>
View Replies !
Variable Price List Database
I am trying to set up a database that can process orders from my clients. The tricky part of this is that tha clients book me for a service and I guarantee the prices for any add-on products from the time they book up until 8 weeks after the service is complete. Then prices revert to whatever the current prices are at the time of ordering. Does anyone know how I would go about setting up tables in MySQL to handle the different pricelists and processing of orders like this?
View Replies !
How To Format A Database With A Field That Has A Table Or List?
Can someone help me to define a format of a database, or a table that has a field that will have tables in that field? Please look at the example and explanation below: Table: Roster --------------------------------------------------- |User Name | User ID | Status | Daily Activity Log | --------------------------------------------------- |John Doe | 1001 | Active | (Tabulated activity)| --------------------------------------------------- |Mary Doe | 1002 |inactive| (Tabulated activity)| --------------------------------------------------- Above is a brief description of the table. I would like for the last field to be a table (or table like) format or list that will include a number of fields of the users' activity. One user might have one or two items in his list. Another person might have 10 or 100 items in their list. The table-like list of the daily activity log column will include something like the following: 1) Date/time of activity 2) Number of people involved in this session 3) Total time of this session 4) Location of the session 5) Session rating (completed/incomplete) The activity log field may have 10 of these entries in one day. The next day it might have 5 entries in this field. The following 3 or four days there might not be any entries.
View Replies !
Using A Field, Which Is A Comma Separated List, As The List In An IN Comparison Test.
The following query only reads the first character of a comma separated list stored in a field of the records being queried. The varchar field in table d named "display" holds 1,4 The query " select * from d where 4 IN (display) " tests false. If I change the field "display" to 4,1 Then the query tests true. It is either testing only the first character, or is stopping at the comma. I need this to test true if the value is anywhere in the list, what am I doing wrong here?
View Replies !
Loading Database From Multiple Text Files Each Containing A Partial List Of Columns
I'm kind of new to mysql. I would like to know if there is a way to use load infile or mysql import syntax to load one table with multiple files each containing a partial list of the table's columns: Table contains : ID, first name, last name, occupation, salary There are two files one containing the first three columns, the other the first field (ID) and last two fields. Is there a way to load them with just two load statements? Note: I know that they can be loaded into two tables and later joined where ID is equal, but the actual example is about 30 text files rather than two, which is a bit too much.
View Replies !
Full List Of MyTable21 And Some List Of MyTable22
data in myTable21 (id) country (1) Canada (2) France (3) Egypt (4) America data in myTable22 (id) city name (1) Montreol Jane (2) Paris Mary (3) Cairo Tom (4) New York Jane (4) Chicago Tom I have data in myTables like the above. The following code produces the following result. but I like to produce my target result. code1 select myTable21.id, name, country, city from myTable21 left join myTable22 on myTable21.id=myTable22.id where name='Tom' result1 (3) Egypt Cairo (4) America Chicago target result1 (1) Canada (2) France (3) Egypt Cairo (4) America Chicago code2 select myTable21.id, name, country, city from myTable21 left join myTable22 on myTable21.id=myTable22.id where name='Jane' result2 (1) Canada Montreol (4) America New York target result2 (1) Canada Montreol (2) France (3) Egypt (4) America Chicago code3 select myTable21.id, name, country, city from myTable21 left join myTable22 on myTable21.id=myTable22.id where name='Mary' result3 (2) France Paris target result2 (1) Canada (2) France Paris (3) Egypt (4) America How can I get the full list of myTable21 and selected values from myTable22?
View Replies !
Mac User First Database
Hi. Im trying to make a database. Seeing as im 14 i have barley any experience with databases. The only ever experience ive had is about 4 lessons of how to create a database in microsoft accses at school! Is there any program like microsoft accsess out there for mac?
View Replies !
Add A User To A Database
I would like to add a user to a database. A very simple thing you would think, but I can't get it to work. This is what I have: GRANT ALL ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'my password' flush Privileges; But for some reason this doesn't work. The user already exists, so could that be the reason? I just want to give it permissions to this new database i've created now.
View Replies !
Creating List Of People Not On List
I am using the following query to try to get a list of people not in a specific list. I can further restrict it by company name but I am getting duplicate entries if the person is listed on multiple lists. (It is further reduced by a clause to restrict by company, but that is not causing errors AFAIK) SELECT people.`First Name`, people.`Last Name`, people.PersonID, Company FROM people LEFT JOIN listtrack ON people.PersonID=listtrack.Person_ID WHERE (listtrack.List_ID<>4 Or listtrack.List_ID Is Null) If I remove the List_ID<>4 clause then I get people who are not on any list., but I want to be able to add one person to multiple lists, without running the risk of data duplication.
View Replies !
Assign A User To A Database
ive just created a new database with no tables in as yet. ive created a new user 'myusername' with a 'password' and i have granted all the priviledges for my new user name and flushed but how do i assign myusername and password to my newdatabasename? e.g my database is called 'shop' how do i assign me to that database?
View Replies !
Is A New User Cannot Create Database?
I have recently installed MySql and graphical tools to manage. After installation with root password set, i have connected with graphical admin tool and created a user and set all the previlages to mysql database. I connected with the newly created user and, Using MySql Query browser, i tried to create a new database (or schema) I got an error Access denied for user 'ADMIN'@'%' to database 'TestDB' My host is : localhost My initial doubt is 'Whether a new user, created by root, cannot create his own databases?
View Replies !
1 MySQL Database Per User
Is there a way for me to limit one mysql user per database? For instance, I have 3 databases: A, B, C mysql_user: aaa mysql_pass: aaa mysql_hostname: locahost mysql_db: A mysql_user "aaa" can have access to database B or database C just by changing mysql_db to "B" or "C". I just want to assign database A to mysql_user "aaa", and not allow mysql_user "aaa" to have access to database "B" or "C" by changing mysql_db to "B" or "C".
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 !
Wp-Forum DB
I get this problem whenever I go to my forums page. PHP Code: WordPress database error: [Unknown column 'sort' in 'order clause']
View Replies !
Set Up New Forum
I would like to set up a forum on an FTP server. I have downloaded a Forum template but I do not know how to use MySQL with it. How should I upload it and make it useable for people? I do not have the luxury of spending very much money, this would be a Guild Thread for people that play an mmorpg with me.
View Replies !
DB For A Forum.
i have worked with DB before but not with mysql and not on this level.i need to create a DB for a forum i have downloaded, but where to start? i am using apache2triad. i am aware i have to create a DB for the forum but i have no info on how. i create a DB and it wants to know about tables and so-on. now what do? how many tables do i need and where will i get this info.
View Replies !
Forum
I am thinking of making a forum from scratch using PHP and MySQL, what would be thwe best way of doing this?
View Replies !
Database - User Table - Propagation
I've started a new website and I want to have a database that works with all my other user tables in my other databases. This is my idea. Background. Example Setup Tree --Main Page: -->Forums -->Mail -->Collaboration -->Bug Reporting -->Etcetera -->Etcetera -->Etcetera *NOTE: Each subsection has it's own database with their own user tables ------------------------------------------------------------------------------- UserX visits my site. There's a register screen and UserX performs the standard Registration which is then added to the userdb in the usertable. I want to run a query that will update all subsequent user tables of their own databases. So, one query or multiple queries will register UserX's info into all those databases. Once the person is logged into the site, the don't need to register nor login into the other portions of my site, they just click on 'said' link and have access to that portion of the site.
View Replies !
Lock A User To A Specific Database
How can I create a new user, that only have access to his/hers database? It's because I host my brother and my own site on my own server, but I have access to his databases, and he has access to my. How can I solve this?
View Replies !
Can I Set Database User Password When No Root Pw Is Set
I have installed PHPBB MediaWiki and SugarCRM on Ubuntu Server LAMP. I initially tried to set the root password on install and then could not log back in. After reinstall this is what I did for a new non root user. root@invest:~# mysql -V mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2 grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost; set password for paul = password('mysecretpassword'); flush privileges; exit; Then when i go to login with this user I can't. I have not set a password for root because the same thing happened when I tried to set root pw immediately after install of the database. This time I am trying to work out the access issue with a new user i have created. This way I still have access since and I won't have to reinstall the db.
View Replies !
Importing And Setting Up New Database And User
I am having trouble moving a database and website from another host. Do we need to use the same user name and password that was previously setup? We changed the code to use the root and root password, seems some pages work and some are blank. I could not see how to setup a new user? so then we can try and use that to connect. The pages refernce this page main.php that has the following code. <?PHP mysql_connect("localhost", "entaction", "2a3wHTp1"); mysql_select_db("entaction"); $size = 15; ?> This was changed to use the rooot user and password because we could not see how to setup the same user for the database, I was able to import the database fine and shows in the databases? Need help getting this working using: phpMyAdmin - 2.8.1 MySQL client version: 5.0.24 Thank you for any help.
View Replies !
Creating User Login With Database
I'm fairly new to using databases and I am wondering how you go about creating a user login with your database. I need to create a login system for a website. Would you use a CREATE USER statement every time you want to add a user, or is that a way for having developers access the database only? I also thought of creating a user table that would contain the users name and password, but how secure would that be?
View Replies !
Creating A User For Only One Database For The Web/ FORGET IT
If I wanted to create a user for only my website to only have access to one database and they will be connecting via php, what is the best way? I should manually insert into the users table, correct? INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); This is the example from mysql docs, but the whole page is huge and seems complicated. Will this mean that only a user coming from the local host will get in this way? And where would I specify the database? I'd like to have just php connecting to the database asside from root and that user only accessing one database to do inserts/updates/deletes and selects.
View Replies !
Unable To Add A A Normal User Into A Database
I hv installed MYSQL server version: 5.0.13-rc on my solaris 8 machine. I hv reset my root password to '' . Now when I m doing following to create a user with the name bugs, I m not able to see it after creating it . although I m not getting any error while creation. My steps are :- bash-2.03# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 119 to server version: 5.0.13-rc Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> select user,host from user ; ERROR 1046 (3D000): No database selected mysql> use bugs; database changed mysql>GRANT ALL PRIVILEGES ON bugs.* TO bugs@localhost IDENTIFIED BY 'bugs' ; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges ; Query OK, 0 rows affected (0.00 sec) mysql> select user,host from user ; ERROR 1146 (42S02): Table 'bugs.user' doesn't exist I do not know why it is not showing the bugs user or what is wrong in my way.
View Replies !
Limited New User At Mysql With One Database!
example: i have account root at linux and i want to create new user at mysql server and create database for my new user. new user :alex password : made database :db_alex TO create new user: alex mysql> insert into user values('localhost','alex',password('made'),'Y','Y','Y','Y','Y','N','N','N','Y' ,'Y','N','Y','Y','Y'); To cresate database : db_alex mysql>create database db_alex Question : what script at php and mysql to limited user : alex , to access only one database : db_alex user alex can't access other database, except database db_alex. user alex can't drop, modyfi and alter other database, except database db_alex.
View Replies !
|
TRACKER
