Recent Questions

I have Windows 10 on a Surface Pro 3. I am trying to use Visual Studio Code. Unfortunately, there seems to be no combination whatsoever where I can run my program. Any time I hit F5 or ctrl f5 or shift f5, the windows 10 search bar from the OS pops up. There seems to be no way to make the application received the F5 before the OS and I can find no way to swap any key to make the program Let's block ads! بخوانید,f5 on my stove,f5 on my oven,f5 mysql,f5 mysql monitor,f5 my policy,f5 mysql password,f5 mysqld high cpu,f5 mysql failover,f5 my logout php3 error code=19 ...ادامه مطلب

I have a MySQL database that was created from data output by another application. On of the columns is for an email address, however the data in this column is all duplicates. For example, the "email" for a single record looks like this "[email protected],[email protected]". I would like the field to contain the address just once. Is there a way through a MySQL command, to remove anything from the , onward? I know I can write a PHP script to loop through all the data, but i was hoping there was a simpler way through MySQL. This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.Recommended article from FiveFilters.org: Most Labour MPs in the UK Are Revolting., ...ادامه مطلب

I'm trying to restart my mysqld process on CentOS 6.6. I have root access to the server and when I run top, this is the first line: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3874 mysql 15 0 2859m 336m 7188 S 120.5 16.4 74730:50 mysqld Clearly there is an issue there (and I may need to increase the DB server since it's maxing out) but the first step I want to take is to put the process through a power cycle to restart it since it hasn't been restarted in a very long time. I've tried as root to do many different processes: service mysqld restart (I get service not found) If I run which mysqld I get /usr/sbin/mysqld . I tried: /usr/sbin/mysqld restart That didn't work. I tried: /etc/init.d/mysqld restart That didn't work. Do I need to be logged in as the mysql user to do this? I figured root would be able to do this but I guess I just can't find the correct way to restart the server. Thanks for your help! This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.Recommended article from FiveFilters.org: Most Labour MPs in the UK Are Revolting., ...ادامه مطلب

Just experimenting with mysql and batch file (call me nostalgic :-) ) echo SELECT some_field FROM some_table WHERE some_field like '%needle%' G > command.sql mysql -s -q -h %svr% --user=%user% --password=%pass% %database% < command.sql This command works perfect for numerical results, but for string results, it is just blank. even if I list the complete table result, it shows all the numerical values, but the field that has strings it is just blank. example 2 rows have "jane doe", and mysql displays ************* 1. row *********************** Name: ************* 2. row *********************** Name: but age works ************* 1. row *********************** Age: 33 ************* 2. row *********************** Age: 105 Is there a setting I can use? ps this is obvious a simplified version of what I am working with. Most my tables have over 40-50 fields. I can do all this in pasca/qb64/VB/php etc. Just wanting to expand some batch skills Let's block ads! بخوانید, ...ادامه مطلب

$serveame = 'edited'; $useame = 'edited'; $password = 'edited'; $dbname = 'edited'; $name = $_POST ['name']; $email = $_POST ['email']; $number = $_POST ['number']; $manufacturer = $_POST ['manufacturer']; $birth = $_POST ['birth']; // Create connection $conn = new mysqli($serveame, $useame, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; $sql = mysql_query("INSERT INTO hgcasestudy (name, email, number, phonename, birthday) VALUES ($name, $email, $number, $manufacturer, $birth)"); if (!$sql) { die('Invalid query: ' . mysql_error()); } $conn->close(); I keep getting the error message: Connected successfullyInvalid query: Access denied for user 'edited'@'localhost' (using password: NO) I'm confused because $serveame is not set to local? I think it's just out of syntax with other parts of the page. Any ideas? Many thanks. Let's block ads! بخوانید, ...ادامه مطلب

Yes, I know this question has been asked here: http://stackoverflow.com/questions/25086363/how-to-create-a-zero-or-one-to-many-relationship-in-mysql-workbench However, at least in MySQL Workbench 6.3, there is no 'NN' check-box under the Foreign Keys tab. Therefore, the answer given is inadequate. Let's block ads! بخوانید, ...ادامه مطلب

I have 2 exchange servers (EXCH1 and EXCH2) that have Exchange 2013 on them. They are both on Windows Server 2012 R2 (Standard) machines. They are also a part of a DAG (Database Availability Group) (DAG1). Both servers are CAS (Client Access Server) and MAILBOX roles. Currently, my router NAT settings are forwarding ports 25, 110, 80, and 443 to EXCH1. Would it be possible to port forward to DAG1 for these ports and let the Failover Cluster Manager decide which machine to use? I tried Network Load Balancer, but it cannot co-exist with Failover Cluster Manager. Let's block ads! بخوانید, ...ادامه مطلب

I am trying to install Wordpress using Microsoft's web platform installer. I went to the Microsoft website and downloaded the installer, and it walked me through the installation. I was prompted to set a MySQL password and it then started installing MySQL itself and froze. It shows download progress at 100% but this progress bar has been going for about an hour now. As you can see, there is not really any activity coming from the installer. Sorry for my sloppy mouse drawing. How can I fix this? Let's block ads! بخوانید, ...ادامه مطلب

I am deploying failover clustering on windows server 2012 r2 enterprise When validate configuration, failover cluster validation report an error At system configuration > Validate Active Directory Configuration This is error message: Connectivity to a writable domain controller from node srv-12-01.clusterdomain.local could not be determined because of this error: Could not get domain controller name from machine srv-12-01. Connectivity to a writable domain controller from node srv-12-02.clusterdomain.local could not be determined because of this error: Could not get domain controller name from machine srv-12-02. Node(s) srv-12-01.clusterdomain.local srv-12-02.clusterdomain.local cannot reach a writable domain controller. Please check connectivity of these nodes to the domain controllers. I have 1 domain controller, 2 member server (joined domain and login with domain administrator user) Can anyone help me? Thank you Let's block ads! بخوانید, ...ادامه مطلب

Is it possible to change GUI language in Devart dbForge for MySQL? Wish to change from Russian to English? , ...ادامه مطلب

apache is running good and mysql is running good, xampp is running good also but i cant log in myweb myphp when i try to access it in my network i cant log in. keep coming back at main page instead in my profile password and useame is right. the data is located at htdocs i checked httdp config is right. what is my mistake or error. Let's block ads! بخوانید, ...ادامه مطلب

I am a new fedora user and i am installing ROR on my machine. but when i try to enter the following command "rake db:create" it shows the following errors. can any one please tell me how can i solve this problem. [smehsan@localhost proone]$ rake db:create '/var/run/mysqld/mysqld.sock' (13 "Permission denied")> Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>5, "useame"=>"root", "password"=>nil, "socket"=>"/var/run/mysqld/mysqld.sock", "database"=>"proone_development"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"} (If you set the charset manually, make sure you have a matching collation) '/var/run/mysqld/mysqld.sock' (13 "Permission denied")> Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>5, "useame"=>"root", "password"=>nil, "socket"=>"/var/run/mysqld/mysqld.sock", "database"=>"proone_test"}, {:charset=>"utf8", :collation=>"utf8_unicode_ci"} (If you set the charset manually, make sure you have a matching collation) [smehsan@localhost proone]$ Let's block ads! بخوانید, ...ادامه مطلب

I like to create a local WiFi network for a bunch of devices, that connects to the inteet via another Wifi AP or UMTS WWAN, if the WiFi connection fails. As there are many devices in the local WiFi network, but the environment network may change (ETH cable, some WiFi or none of them), the local network would provide a constant configuration for my local devices. There are routers that provide WWAN failover, but they only provide AP mode (the Inteet is connected by Etheet then) or client mode (The inteet is connected by WiFi, but there is no local WiFi AP then). There are routers with "Universal Repeater Mode", which allow to create an local AP while still being client in some other WiFi. So it is possible to have AP WiFi, client WiFi and WWAN failover if the client WiFi fails on the same device? Or are there reasons that make this impossible? What features I would have to look for to find such a device? Let's block ads! بخوانید, ...ادامه مطلب

So a followup to my other question: http://stackoverflow.com/a/37057476/2890156 I've tried port-forwarding as suggested here: http://stackoverflow.com/questions/19749599/openshift-how-to-remote-access-mysql but when I try rhc port-forward -a myapp it gives me an error: Error trying to forward ports. You can try to forward manually by running: ssh -N [email protected] So when I execute the command it gives me another error: Failed to add the host to the list of known hosts (/.ssh/known_hosts). Permission denied (publickey,gssapi-keyex,gssapi-with-mic). I tried adding my host to the known_hosts file but apparently I don't have access to the file. I've searched for a solution and came accross this post which has the same problem: http://stackoverflow.com/questions/24113522/rhc-not-working-on-openshift-instance?ref=driverlayer.com/web but it doesn't get answered. So I'm posting it again to find out why port-forwarding isn't working and how to fix this problem. Let's block ads! بخوانید, ...ادامه مطلب

Rename a folder from XYZ to ABC. The new name is not visible in Explorer. Double click (or press enter) on the folder. Windows will say "Folder cannot be found". It appears that Explorer is not aware that the folder was not renamed. I have seen some fixes for this on the inteet but none for Windows 10. Let's block ads! بخوانید, ...ادامه مطلب