Enabling SSL & Setting Up A Certificate
I have MySQL 5.0.27 on XP Pro. I have not been able to find the correct syntax for starting MySQL so that SSL is enabled.I've searched the forums and the Manual.
ALso, can anyone point me to a location which provides clear guidance on setting up an SSL certificate? %.9.7.4 of the Reference Manual wasn't too helpful for me.
View Complete Forum Thread with Replies
Related Forum Messages:
Enabling InnoDB
Actually am using mysql 5.0 version, default it using MyISAM engine, but i wnat ot use InnoDB engine. I tried to change the my.cnf file with entry "default_server_engnie=InnoDB".but there is no use.
View Replies !
Enabling InnoDB Error
I've successfully enabled InnoDB for my database but I'm getting the following error when I try and set on delete cascade for a foreign key. Error SQL query: ALTER TABLE `editors` ADD CONSTRAINT `participants_editors` FOREIGN KEY ( `account_id` ) REFERENCES `participants` ( `id` ) ON DELETE CASCADE MySQL said: Documentation #1005 - Can't create table './isimodev_co_uk_main/#sql-7d1_4c69.frm' (errno: 150)
View Replies !
Enabling Binary Log In Mysql 5.0.45
I wrote log_bin=[filename] in my.inf and restarted ,eventhough if checked at commandprompt through show variables statement, its showing log_bin =off.I tried through mysql adminstrator stratup variables also. But no change at all.can anyone tell me how to enable binary logs and further process for replication.Awaiting for your valuble replies.
View Replies !
Enabling Multiple Statements
I'm trying to execute the following multiple statements using MySql w/ the ODBC connector. INSERT INTO Sites(Hostname) values('zzz'); INSERT INTO Hosts(SiteID, Hostname) values(last_insert_id(), 'zzz'); I get the following error: [1064] [1] [0] "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO SiteHosts(SiteID, Hostname) VALUES(@@IDENTITY, 'zzz')' at line 2" Is there something I have to do to enable multiple statements?
View Replies !
Enabling Remote Connections
Can someone tell me how to set up the mysql server to accept remote connections? Im using mysql 4.1 on Linux Ubuntu 5.10 I have tried editing my.cnf and changing the bind-address from 127.0.0.1 to the server's IP address, but this just results in the server failing to restart with the following error: Starting MySQL database server: mysqld...failed. Please take a look at the syslog. /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! What do I have to do to get it to accept local and remote connections? Code:
View Replies !
Setting Up An ISP
I am trying to figure out how to setup an ISP. I have broadband in my shop and was thinking, I could setup the house to call into my network and connect to the Internet through my DSL. I have servers with Mandrake 10.1 for web/mail/ftp. Was wondering if this could be done and what needs to be done for it to work?
View Replies !
Setting A New Value
I'm trying to design an internet forum these days ... In my database i have got a field called (ID) which represents the id of the topics and i have assigned it an (auto_increment) attribute... My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic, so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?
View Replies !
Setting Value
I have a table (cont_id) with an auto_increment primary key, and I had deleted entries with much higher numbers than others.Those entries are no longer there, but auto_increment sets cont_id based on the high-number entry I deleted.Is there a way to re-set auto_increment so it adds +1 to the highest-number value for cont_id among the existing entries?
View Replies !
Setting Sum
I need to get the sum from one table (table1) and update the second table(table2) based on 'id' field. Not sure what statement/function to use? .............
View Replies !
Setting It Up
I need help on setting mySQL 4.0 on my windows 2000 small business edition server. how exactly do i do it? its downloaded, and set-up, now how do i use it?
View Replies !
Setting Up
I am wanting to set mysql/php on my mac. Im wondering if installing mamp is the same as installing each component seperately. Can i get away with mamp or should i go through and set it up manually?
View Replies !
Setting Value Of Row_count()
i have a stored procedure consisting of several delete statements and i want to be able to return the "Query OK, 0 rows affected" such that the total number of rows deleted are summed up rather than returning the number of affected rows of the last statement. the number of rows deleted can be obtained through the ROW_COUNT() and i can add it up. but how do i set the value of the "Query OK, XXX rows affected"?
View Replies !
Setting Up Privileges
if I can restrict a user from a single table. I want him to be able to create,alter,delete all the tables but one, which I want him not to delete it, not to update it not to create it.Just to use it. Can I do it? As long as I have read there is only the way to give credentials for all the objects of the database.
View Replies !
Setting Value For All Records
How would i go about populating a new column based on an existing column pluse a bit of text. i.e i have a column fldID which contains numerics 1,2,3,4 etc and i want to poulate a column fldIMAGE with values 1.jpg, 2.jpg etc.
View Replies !
Setting Up MySQL On Mac OS X
I'm a novice Unix user, and I can't get MySQL set up properly on my Mac. It seems to have installed OK, but when I try to run the mysql_install_ db script, I get errors. I can't set the root password either that the documentation tells me to. As background, I just want to use MySQL to work with databases and PHP and HTML to set up web pages for database input and output. I'm running MySQL on my own machine at home, and have no use for passwords or any other administrative functions. I'm just looking to use the program to set up and query databases. Can anyone point me to a way to avoid all the UNIX admin stuff and run the database? I can get in, but the mysql database doesn't appear when I hit SHOW DATABASES as the tutuorial says, and I can't access or create new databases. I think all this may have something to do with my user account on my machine, but I'm not savvy enough to know how to override permissions, be root, or any of that stuff. Any hints?
View Replies !
Setting Constraints
I want to create a table and set a constraints on a fields. For example for the int field all the inputs has to be greater then 5. How do I go about doing it? I tried this create table Foo( id integer(5) not null, constraint id_range check(id>5)
View Replies !
Setting Input
I'm using Navicat to develop MySQL database. I have a table cutomer table that will be connected to Jsp page to collect data from the user online. I was wondering how do I set an input mask to the email address: such as: abc@yahoo.co.uk into xxxxxx@yyyyyy.zzzzzz So this means that the user must enter their email address in that format otherwise it should return a message saying INVALID. Also another question was: Im trying to set my price field in such a way that it accepts values like 2.50 but i tried using Double, real, numeric, float but it does not allow the zero at the end.
View Replies !
Setting Up On XAMPP
This is how the server is started: mysqlinmysqld --defaults-file=mysqlinmy.cnf --standalone --console There's no "--old-passwords" but it's still not working. I have Xampp, btw. In my.cnf I took out the "old_passwords" declaration. I restarted the server a few times and it's still not working.
View Replies !
Setting Up Table(s)
I am creating a database for fashion designers. Each fashion desiger is an a table named "authorize" and have an id of "member_id". The question comes in setting up the table(s) to enter their styles of work. I am at a bit of a loss of where to start. A quick example would be there is a master category of shoes, under which there are sub-categories: (pumps, clogs, boots, athletic shoes, etc...) *there will be other categories like clothes, dresses, etc.. which will of course of other subcategories. The subcategories have styles (Toe Type, Color, Heel Type, etc...) Each of the categories could be either men or women. How would I set this up? Whould this be several tables, with several more lookup tables? Or could it just be one table with an id that ties each together? I know that somehow there would be a lookup table for the product to user.
View Replies !
Setting UpOnline DB
I am just about to start setting up an online database to show a list of clubs and the firms who help run them as volunteers. A firm may run a number of clubs and a club may be run by any number of firms. I was going to set up a table for the clubs with the usual fields (id, name, add1, etc) and a table with the firms (firmid, name, organiser, etc). My question is, how do I link the firms and clubs? If it was a club only ever had a single firm I would just put the firmid in the club table, but as it could be any number of firms I am not sure how to structure it.
View Replies !
Setting Variables
I am using win and mysql 4.1, I found that I can't set variables in my.ini config file, msqld part, such as: --- character_set_results=latin1 character_set_connection=latin1 --- error, it seems no such variables for setting, but some variables such as: --- slow_launch_time = 1 --- can be set in the config file.
View Replies !
Setting The First Row In JDBC
Consider a table with 100 entries in it. Say, I execute the following query from a JAVA application using JDBC: - SELECT * FROM foo_table LIMIT 10 ORDER BY start_date DESC; Due to 'LIMIT 10 ORDER BY start_date DESC' it will return me top 10 results. How can I retrieve the next 10 in some later query, totally independent of any current query? I wish to do something like the Hibernate function Query.setFirstResult(int index); but using JDBC.
View Replies !
Setting Up Directories
I need to setup on which directories on my hosted servers. I am a member of a volunteer organization, but would like to have a wiki posting to help promote some of the events that have lower turnouts. Also to get comments and perhaps media from some of the more successful events. I'm very new to this and am still reading up on some reference materials, but would like to have something tangible to work off of. Our budget is limited as well so I opted for the low budget plan for now, so I am still uncertain of the bandwidth I need.
View Replies !
Setting Variables In My.cnf
how can I issue these client commands from inside the my.cnf file? tep_db_query('set collation_connection=euckr_korean_ci', $link); tep_db_query('set character_set_results=euckr', $link); tep_db_query('set character_set_connection=euckr', $link); tep_db_query('set character_set_client=euckr', $link);
View Replies !
Setting Up A SQL Table
I want to use this: $sql = "SELECT * FROM blogroll ORDER BY rand(" . time() . " * " . time() . ") LIMIT 1"; To pull random code into my WordPress theme (I will need to use lots of these random entries, so this method looks best, ATM). Do I use this by creating a table in my database and replacing "blogroll" in the above line with the name of the table(say: randomphp)? I will try this as soon as I figure out how to fill in the fields in the new table. If I am correct about what I need to do please help me out with the fields on the table creation screen in phpMYadmin: Field? The code I want to put in place of the SQL string in my theme, right (a php include to be specific)? Type? Length/Values*? Attributes? Null? Default**? Extra? primary, index, unique, or ---? full text?
View Replies !
Setting Password
I successfully added MySQL, setup db's and did initial app development. I did all of this under the root user and blank password. When I ported the new development to the web site I tried to setup a user and password for the application and set the root password and ran into a brick wall. I am now locked out MySQL in terminal mode, phpAdmin will not save a config, MySQL GUI Admin will not save passwords and under options it says it cannot locate the /etc/my.cnf file. I have looked at a number of tutorials to set up the my.cnf file and they seem to conflict with one another and have been reticent to take action to make sure I was going in the correct direction. I am using QS10.4, phpAdmin 2.11, MySql 5.05, GUI Tools for 5.0. Can anyone point me the right direction to line up all of the security related files to get control back, successfully run the app on the local environment and and continue development.
View Replies !
Setting Up A Username
I am both the user and the admin. I am using winXP, and I am the root. This is all happening on one laptop since I am using Apache as a server. I have to ONLY provide mysql with my password to get into my database. My Q is how can I assign an actual username to myself, so MySQL connects my password that is already in use with the new username which I don't know how to create?
View Replies !
Setting Autoincrement On Max()
i have some legacy DB that uses 0 in an auto increment column. this causes me to fail on alter column to an auto_increment if i run this: ALTER TABLE `t` AUTO_INCREMENT=1000, MODIFY COLUMN `t_id` INTEGER NOT NULL AUTO_INCREMENT; everything works fine but if i try : set @maxs:= select max(t_id) from t; ALTER TABLE `t` AUTO_INCREMENT=@maxs, MODIFY COLUMN `t_id` INTEGER NOT NULL AUTO_INCREMENT;
View Replies !
Setting Up Database
im going to use mysql for my database and then i will you asp for programming. im using windows xp pro in a lan. can the computer in the lan access my database thru webpages hosted on my computer using IIS.
View Replies !
Setting Up A Relation
Is there any reason why two tables created with a relation in MySQL wouldn't adhere to what you would think is a property of the relation? Case in point: I have a 1:n 'relation' where I can insert values into the dependent table while making up an entry for the foreign key from the independent table (whether it exists or not). I shouldn't be able to do that, but MySQL doesn't complain.
View Replies !
Setting Up Defaults
Is there a way to set-up defaults to the fields using some SQL statment instead of going into each field and entering default values.
View Replies !
Setting A Maximum
I'm trying to get summaries of articles from my database, and I've tried a couple things though none of them seemed to be correct. In my SELECT statement: SELECT * FROM articles WHERE id=$_GET[id] I want to specify how many characters(maximum) it should return. The field I want to limit is longtext and there are three other fields (2 varchars, and a date) but none go over 30. I assume that this is possible since creating a separate field that contains a summary would be extra overhead.
View Replies !
Setting Mysql
I'm setting up mysql server for the first time and after logging into the command prompt I setup a new super user and deleted the root user for security reasons. Now it seems I can't login to the server at all. MUST you have a root user to run a mysql server? If not, how can I login to do anything?
View Replies !
Using And Setting Up My First Database
1. how do I being in setting up my mySQL database which will be storing files consisting of TXT, SWF and images. 2. I want to be able to call these items from the database using PHP links and MySQL/PHP integration. Any tutorials on the web available for that that anyone knows of? 3. Easability. Where can I go to learn how to optimize all my code?
View Replies !
Setting Up / Removing
I tried removing MySQL But when asked for my password it would let me type it & Im log in as admin. Please Help ASAP I need a MySQL Project done. here is the terminal line: [flash-AlPB-1GHz:/usr/local] chadelso% [flash-AlPB-1GHz:/usr/local] chadelso% cd /usr/local/mysql [flash-AlPB-1GHz:/usr/local/mysql] chadelso% cd /usr/local sudo rm mysql sudo rm -rf mysql-3.23.47-apple-darwin5.1-p [flash-AlPB-1GHz:/usr/local] chadelso% sudo rm mysql Password:
View Replies !
Setting Up The Server
I keep getting an error number 1045 access denied whenever I try to run MYSQL Administrator. I just set this up. What did I forget to do? I installed MySQL Server 5.0, the administrator, the query browser and the system tray monitor. What am I forgetting to do here?
View Replies !
Setting All Instances Of A Value To Zero?
I am writing a basic CMS for a project and i need to be able to set every instance of a value to zero in a mysql database. eg. there are 20 entries, each with the value '1' in the 'default' column. I want to change all of their 'default' values to 0 in one query. How can i do this?
View Replies !
Setting Up New Item
I use myphpadmin and I am a beginner with it. I have this text based game and for items it's weapon, armor and shield. I went to insert and did the fields and added a new item called "Herb" which heals your character 10 health. So now I go to the game to the admin control panel and its there but it can only be a weapon, armor or shield. I need to add a new class for "items" which is a healing item.
View Replies !
Setting Up Users
I have a website and db where people can login get setup and then enter information into the db, everybody has a unique client number, can I create a user for the db when they set themselves up as a user and restrict them from changing anything except data that is connected to their client number?
View Replies !
Setting Up First Database
This is of course a MySQL database, which I will be accessing with PHP. Ultimately it will need the functionality to output all entries beginning with a certain letter onto a page, in alphabetical order. My question (for now) is : Is it necessary or would it make it easier in the future if the database has a field for 'first letter'? I won't necessarily be inputting these entries in alphabetical order so I won't be able to rely on the id to put things in the proper order. Some general guidance on outputting things in order like this would be helpful as I don't want to set up a database table and do loads of data entry only to find it's not right.
View Replies !
Setting The ORDER BY
ok say a field name in a table is called "type" and there are 4 possible values for the "type" field (car, boat, motor, rv). I dont want to order it by ascending or descending i want all the rows labled car under the "type" field to apear first. and the same for rv, boat, and motor. How would i acieve this??
View Replies !
|
TRACKER
